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);
}

}
问题描述:不能添加用户到数据库,请大家给出原因!
...全文
469 1 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
孟子E章 2018-03-11
  • 打赏
  • 举报
回复
首先,断点调试下是否进入到了代码执行的流程, 再次,检查服务器的日志看报告什么信息

24,923

社区成员

发帖
与我相关
我的任务
社区描述
Web 开发 Apache
社区管理员
  • Apache
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧