写了个javabean处理数据库的操作 然后jsp页面调用 出现了点小疑点 调试了很久
写了个javabean处理数据库的操作 然后jsp页面调用 出现了点小问题 调试了很久
javabean类
jsp页面
javabean类
package javabean;
import java.sql.*;
public class chuli {
private Connection con;
private Statement stm;
private String drivername="com.mysql.jdbc.Driver";
private String url="jdbc.mysql://127.0.0.1:3306/yonghu";
public chuli(){}
public Connection getCon(){
try {
Class.forName(drivername);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
con=DriverManager.getConnection(url,"root","1414519845");
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
con=null;
}
return con;
}
public Statement getStm() {
try {
con=getCon();
stm=con.createStatement();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return stm;
}
public int insert(String sql)
{
int num=-1;
if(sql==null)sql="";
try {
stm=getStm();
num=stm.executeUpdate(sql);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return num;
}
public ResultSet select(String sql){
ResultSet rs=null;
if (sql==null) {
sql="";
}
try {
stm=getStm();
rs=stm.executeQuery(sql);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return rs;
}
public void closed(){
try {
if(stm!=null)stm.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
try {
if(con!=null)con.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}
jsp页面
<%
String username=request.getParameter("username");
String usersex=request.getParameter("usersex");
String userage=request.getParameter("userage");
username=new String(username.getBytes("ISO-8859-1"),"gbk");
usersex=new String(usersex.getBytes("ISO-8859-1"),"gbk");
userage=new String(userage.getBytes("ISO-8859-1"),"gbk");
String sql="insert into user values('"+username+"','"+usersex+"','"+userage+"')";
chuli hr=new chuli();
int i=hr.insert(sql);
hr.closed();
out.println(i);
if(i>0)
{
out.println("<center>");
out.println("<b>注册成功!</b>");
out.println("<table width='300' height='150' style='margin:50' cellspacing='0' border='1' bordercolor='black' bordercolorlight='white'>");
out.println("<tr height='25'><td colspan='2' align='center' >你的信息如下</td>");
out.println("</tr>");
out.println("<tr><td align='center' >昵称</td>");
out.println("<td>"+username+"</td>");
out.println("</tr>");
out.println("<tr><td align='center' >性别</td>");
out.println("<td>"+usersex+"</td>");
out.println("</tr>");
out.println("<tr><td align='center' >年龄</td>");
out.println("<td>"+userage+"</td>");
out.println("</tr>");