作为一个初学者我崩溃了。。。求修改。。。能查询不能插入。。。

Question

public class DepartmentDao {public List<Department> searchAllDepartment() throws SQLException {

List<Department> DepartmentList = new ArrayList<Department>();

Connection conn = DB.getConnection();
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select * from departmentinfo"; ps = conn.prepareStatement(sql);
//当执行一个查询语句(select)的时候，使用executeQuery()。
rs = ps.executeQuery();
//当执行一个更新语句(insert,delete,update)的时候，使用executeUpdate()。
//int iRet = ps.executeUpdate();
while(rs.next()) {
Department d = new Department();
   d.setDepartId(rs.getString("departId"));
   d.setDepartName(rs.getString("departName"));
   d.setDepartNum(rs.getString("departNum"));
   d.setDepartDescrip(rs.getString("departDescrip"));
   
   DepartmentList.add(d);
}
return DepartmentList;
}
}

Answer 1

package cn.usermanage.departservlet;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import cn.usermanage.db.DB;
import cn.usermanage.entity.Department;
import cn.usermanage.service.DepartmentService;public class DepartServlet extends HttpServlet{


private static final PrintWriter String = null;
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

 
//查找所有的用户信息。
DepartmentService d = new DepartmentService();
//调用业务方法

List<Department> ds = null;
try{
ds = d.searchAllDepartmens();
}catch(Exception ex) {
ex.printStackTrace();
}
request.setAttribute("DepartmentList", ds);
request.getSession().setAttribute("DepartmentList", ds);
request.getRequestDispatcher("departmentInfo.jsp").forward(request, response);

String newdepartId=request.getParameter("textdepartId");
String newdepartName=request.getParameter("textdepartName");
String newdepartNum=request.getParameter("textdepartNum");
String newdepartDescrip=request.getParameter("textdepartDescrip"); Connection conn = DB.getConnection();
PreparedStatement ps = null; String sql = "insert into departmentinfo(departId,departName,departNum,departDescrip)vlaues('"+newdepartId+"','"+newdepartName+"','"+newdepartNum+"','"+newdepartDescrip+"')"; try {
ps = conn.prepareStatement(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

try {
ps.executeUpdate();
} catch (SQLException e) {

e.printStackTrace();
}





} 


}

Answer 2

request.getRequestDispatcher("departmentInfo.jsp").forward(request, response);转发了，下面会执行吗？

Answer 3

语句有错~~
String sql = "insert into departmentinfo(departId,departName,departNum,departDescrip)vlaues('"+newdepartId+"','"+newdepartName+"','"+newdepartNum+"','"+newdepartDescrip+"')";
vlaues-->values

Answer 4

写好的sql一定要到库里执行下 看能不能成功 之后再到程序中测试效果 养成好的习惯

Answer 5

lz应该把sql语句打印出来，到查询分析器里面执行以下的

Answer 6

拼写SQL错误，应该打印SQL语句，再工具上执行一遍