50,523
社区成员
发帖
与我相关
我的任务
分享
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
//获取传过来的表单数据,根据表单中的name获取所填写的值
String department = request.getParameter("department");
String leader = request.getParameter("leader");
String according = request.getParameter("according");
String content = request.getParameter("content");
String scores = request.getParameter("scores");
String workshop = request.getParameter("workshop");
String man = request.getParameter("man");
String date = request.getParameter("date");
String cancel = request.getParameter("cancel");
String step = request.getParameter("step");
System.out.println(department);
System.out.println(leader);
System.out.println(according);
System.out.println(content);
System.out.println(scores);
System.out.println(workshop);
System.out.println(man);
System.out.println(date);
System.out.println(cancel);
System.out.println(step);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
import java.sql.*;
public class DBBean {
Connection con=null;
Statement stat=null;
PreparedStatement pstat=null;
ResultSet rs=null;
public DBBean(){}
//取得数据库连接
public Connection getCon(){
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://localhost:3306/test?user=root&password=";
con=DriverManager.getConnection(url);
}catch(Exception ex){
ex.printStackTrace();
}
return con;
}
//执行数据库查询并返回查询结果
public ResultSet query(String sql){
try{
con=getCon();
stat=con.createStatement();
rs=stat.executeQuery(sql);
}catch(Exception ex){
ex.printStackTrace();
}
return rs;
}
//关闭数据库连接
public void close(){
try{
if(rs!=null)rs.close();
if(stat!=null)stat.close();
if(pstat!=null)pstat.close();
if(con!=null)con.close();
}catch(Exception ex){
ex.printStackTrace();
}
}
}
大神们 具体传到数据库的代码我要写在这里是吧?