javaweb添加不知道错在什么地方?
牙签爱狐狸 2018-03-10 02:45:21 这个是方法:public int adduser(String username,String pwd,String sex,String email,
String birthday,String marriaged,String education,String school,
String duty,String town,String tel,String address,String idcard,String id_bank,String department){
int fff=0;
Connection connection=null;
PreparedStatement statement=null;
ResultSet resultSet=null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1:3306/managestaff";
String user="root";
String password="root";
connection=DriverManager.getConnection(url,user,password);
Date entertime=new Date(new java.util.Date().getTime());
String sql="insert into user(username,pwd,sex,email,birthday,marriaged,education,school,duty,town,entertime,tel,address,idcard,id_bank,department) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
statement = connection.prepareStatement(sql);
statement.setString(1,username);
statement.setString(2, pwd);
statement.setString(3,sex);
statement.setString(4, email);
statement.setString(5,birthday);
statement.setString(6, marriaged);
statement.setString(7,education);
statement.setString(8, school);
statement.setString(9,duty);
statement.setString(10, town);
statement.setDate(11, entertime);
statement.setString(12,tel);
statement.setString(13,address);
statement.setString(14,idcard);
statement.setString(15, id_bank);
statement.setString(16,department);
fff=statement.executeUpdate();
} catch (Exception e) {
// TODO: handle exception
}finally{
try {
if (statement!=null) {
statement.close();
}
if (resultSet!=null) {
resultSet.close();
}
if (connection!=null) {
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return fff;
}
这个是servlet:
package com.menagestaff.Srevlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.menagestaff.Dao.UserDao;
/**
* Servlet implementation class registerServlet
*/
public class registerServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public UserDao userDao;
@Override
public void init() throws ServletException {
// TODO Auto-generated method stub
userDao=new UserDao();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=UTF-8");
String username=request.getParameter("username");
String pwd=request.getParameter("pwd");
String sex=request.getParameter("sex");
String email=request.getParameter("email");
String birthday=request.getParameter("birthday");
String marriaged=request.getParameter("marriaged");
String education=request.getParameter("education");
String school=request.getParameter("school");
String duty=request.getParameter("duty");
String town=request.getParameter("town");
String tel=request.getParameter("tel");
String address=request.getParameter("address");
String idcard=request.getParameter("idcard");
String id_bank=request.getParameter("id_bank");
String department=request.getParameter("department");
int fff = userDao.adduser(username, pwd, sex, email, birthday, marriaged, education, school, duty, town, tel, address, idcard, id_bank, department);
request.getRequestDispatcher("Userservlet").forward(request, response);
}
}
问题描述:不能添加用户到数据库,请大家给出原因!