主题:各位老大帮帮忙!!!!
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<html>
<BODY><FONT size=2>
<%
String name=request.getParameter("name");
if(name==null)
{name="";
}
//byte b[]=name.getBytes("ISO-8859-1");
//name=new string(b);
String newpassword=request.getParameter("password");
if(newpassword==null)
{newpassword="";
}
String newEmail=request.getParameter("Email");
if(newEmail==null)
{newEmail="";
}
String newsex=request.getParameter("sex");
if(newsex==null)
{newsex="";
}
String newqq=request.getParameter("qq");
if(newqq==null)
{newqq="";
}
String newaddress=request.getParameter("address");
if(newaddress==null)
{newaddress="";
}
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch(ClassNotFoundException e){}
try{
//conn=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=laoji");
String url ="jdbc:mysql://localhost:3306/test?user=root&password=laoji" ;
//sql=conn.createStatement();
String sql="update user set user_name='"+name+"',user_password='"+newpassword+"',user_email='"+newEmail+"',user_sex='"+newsex+"' ,user_qq='"+newqq+"',user_address='"+newaddress+"' where user_name='"+name+"'";
conn= DriverManager.getConnection(url);
stmt=conn.createStatement();
rs=stmt.execute(sql);
//catch(ClassNotFoundException e) {}
//int up=sql.executeUpdate(sql);
//if(up==1){
//out.println("sql");
//}else{
//}
//rs=sql.executeQuery("select * from user ");
out.print("<table border=1>");
out.print("<tr>");
out.print("<td width=100>username</td>");
out.print("<td width=100>usersex</td>");
out.print("<td width=100>userpassword</td>");
out.print("<td width=100>Email</td>");
out.print("<td width=100>QQ</td>");
out.print("<td width=100>address</td>");
out.print("<td width=100>birthday</td>");
out.print("</tr>");
if(rs.next()){
out.print("<tr>");
String e=rs.getString(1);
out.print("<td>"+e+"</td>");
String f=rs.getString(2);
out.print("<td>"+f+"</td>");
String g=rs.getString(3);
out.print("<td>"+g+"</td>");
String h=rs.getString(4);
out.print("<td>"+h+"</td>");
int i=rs.getInt(5);
out.print("<td>"+i+"</td>");
String j=rs.getString(6);
out.print("<td>"+j+"</td>");
String k=rs.getString(7);
out.print("<td>"+k+"</td>");
out.print("</tr>");
}
out.print("</table>");
// rs.close();
//sql.close();
// conn.close();
}catch(Exception ex)
{
ex.printStackTrace();
out.println("<BR>"+ex.getMessage()+"<br>");
}
finally{
if (rs!=null) rs.close();
if (stmt!=null) stmt.close();
if (conn!=null) conn.close();
}
%>
</body>
</html>
怎么才能实现修改!!谢个位了!帮忙看看!!!
<%@ page import="java.sql.*"%>
<html>
<BODY><FONT size=2>
<%
String name=request.getParameter("name");
if(name==null)
{name="";
}
//byte b[]=name.getBytes("ISO-8859-1");
//name=new string(b);
String newpassword=request.getParameter("password");
if(newpassword==null)
{newpassword="";
}
String newEmail=request.getParameter("Email");
if(newEmail==null)
{newEmail="";
}
String newsex=request.getParameter("sex");
if(newsex==null)
{newsex="";
}
String newqq=request.getParameter("qq");
if(newqq==null)
{newqq="";
}
String newaddress=request.getParameter("address");
if(newaddress==null)
{newaddress="";
}
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch(ClassNotFoundException e){}
try{
//conn=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=laoji");
String url ="jdbc:mysql://localhost:3306/test?user=root&password=laoji" ;
//sql=conn.createStatement();
String sql="update user set user_name='"+name+"',user_password='"+newpassword+"',user_email='"+newEmail+"',user_sex='"+newsex+"' ,user_qq='"+newqq+"',user_address='"+newaddress+"' where user_name='"+name+"'";
conn= DriverManager.getConnection(url);
stmt=conn.createStatement();
rs=stmt.execute(sql);
//catch(ClassNotFoundException e) {}
//int up=sql.executeUpdate(sql);
//if(up==1){
//out.println("sql");
//}else{
//}
//rs=sql.executeQuery("select * from user ");
out.print("<table border=1>");
out.print("<tr>");
out.print("<td width=100>username</td>");
out.print("<td width=100>usersex</td>");
out.print("<td width=100>userpassword</td>");
out.print("<td width=100>Email</td>");
out.print("<td width=100>QQ</td>");
out.print("<td width=100>address</td>");
out.print("<td width=100>birthday</td>");
out.print("</tr>");
if(rs.next()){
out.print("<tr>");
String e=rs.getString(1);
out.print("<td>"+e+"</td>");
String f=rs.getString(2);
out.print("<td>"+f+"</td>");
String g=rs.getString(3);
out.print("<td>"+g+"</td>");
String h=rs.getString(4);
out.print("<td>"+h+"</td>");
int i=rs.getInt(5);
out.print("<td>"+i+"</td>");
String j=rs.getString(6);
out.print("<td>"+j+"</td>");
String k=rs.getString(7);
out.print("<td>"+k+"</td>");
out.print("</tr>");
}
out.print("</table>");
// rs.close();
//sql.close();
// conn.close();
}catch(Exception ex)
{
ex.printStackTrace();
out.println("<BR>"+ex.getMessage()+"<br>");
}
finally{
if (rs!=null) rs.close();
if (stmt!=null) stmt.close();
if (conn!=null) conn.close();
}
%>
</body>
</html>
怎么才能实现修改!!谢个位了!帮忙看看!!!