jsp插入mysql的小问题
String name = request.getParameter("user");
String password = request.getParameter("password");
String sex = request.getParameter("sex");
Connection con = null;
PreparedStatement st = null;
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test";
String sql = "insert into users(name,password,sex) values(?,?,?)";
con = DriverManager.getConnection(url,"root","123");
st = con.prepareStatement(sql);
st.setString(1,name);
st.setString(2,password);
st.setString(3,sex);
st.executeUpdate(); //在这里 SQL语句总是插不到mysql里面 帮我看看 我也没写错啊
session.setAttribute("user",name);
response.sendRedirect("index.jsp");
}catch(Exception r){
response.sendRedirect("register.jsp");
}finally{
if(st!=null){
try{st.close();}catch(Exception e){e.printStackTrace();}
}
if(con!=null){
try{con.close();}catch(Exception e){e.printStackTrace();}
}
}