关于jdbc数据库 jsp的部分操作新手请赐教

a1358442 2017-12-01 02:38:51

<%
request.setCharacterEncoding("UTF-8");//设置request域的字符编码
String userpassword = request.getParameter("userpassword");
String userid = request.getParameter("userid");
String gname = request.getParameter("gname");
String email = request.getParameter("email");
int age = Integer.parseInt(request.getParameter("age"));//从request域中提取值
String hobby = request.getParameter("hobby");
String gender = request.getParameter("gender");
String city = request.getParameter("city");
String characteristic = request.getParameter("characteristic");
/*连接的准备*/
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";//数据库连接地址注意插入乱码!
String JDBCname = "root";//数据库用户名
String JDBCpassword = "123456";//数据库密码
Class.forName("com.mysql.jdbc.Driver");//注册连接到MySQL的驱动就像在两个岛之间造桥有了桥才能交流(提交sql语句和接收数据)
Connection conn = null;//连接类
PreparedStatement pstmt = null;//预处理类 Statement类
PreparedStatement pst = null;
try {
conn = DriverManager.getConnection(url, JDBCname, JDBCpassword);
String countSql = "select count(*) count from user where gname=?";
pst = conn.prepareStatement(sql);
pst.setString(1, gname);
ResultSet countSet = stmt.executeQuery(countSql);
int count = 0;
if (countSet.next()) {
rowCount = countSet.getInt("count");
}
if (count > 0) {
response.sendRedirect("login.jsp?errNo=1");
} else {
String sql = "insert into user (gname,userid,userpassword,email,age,hobby,gender,city, characteristic) values (?,?,?,?,?,?,?,?,?)";
pstmt = conn.prepareStatement(sql);// 使用预处理连接注意顺序!
pstmt.setString(1, gname);// 表示设置sql语句的参数对应占位符 1代表的一个问号
pstmt.setString(2, userid);
pstmt.setString(3, userpassword);
pstmt.setString(4, email);
pstmt.setInt(5, age);
pstmt.setString(6, hobby);
pstmt.setString(7, gender);
pstmt.setString(8, city);
pstmt.setString(9, characteristic);

int i = pstmt.executeUpdate();// 预处理提交
if (i > 0) {
out.print("注册成功!3秒后回到主页面");
response.setHeader("refresh", "3;url=face.jsp");
}// 设置头信息跳转
}
} catch (Exception e) {
out.println("添加失败,错误:" + e.getMessage());// 方法一,输出错误的信息
e.printStackTrace();// 方法二,输出错误的信息
out.println("添加失败!3秒后回到show页面");
response.setHeader("refresh", "3;url=face.jsp");
} finally {
if (pst != null) {
pst.close();// 关闭资源
}
if (pstmt != null) {
pstmt.close();// 关闭资源
}
if (conn != null)
conn.close();// 关闭资源注意需要按顺序关闭顺序与你创建对象时的顺序相反最后创建对象的最先关闭
}
}

...全文