Servlet中如何写jdbc将数据传入到数据库
mx247 2017-07-31 04:46:28 public class Book extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String bname=request.getParameter("bname");
String bnum=request.getParameter("bnum");
String bdate=request.getParameter("bdate");
String bauthor=request.getParameter("bauthor");
String bprice=request.getParameter("bprice");
response.getWriter().write(bname);
response.getWriter().write(bnum);
response.getWriter().write(bdate);
response.getWriter().write(bauthor);
response.getWriter().write(bprice);
}
public void ConnDB(){
ArrayList list=new ArrayList();
Connection con=null;
Statement stmt;
String dbname="***";
String username="root";
String password="*******";
String url="jdbc:mysql://192.168.30.117/"+dbname+"?user="+username+"&password="+password+"";
String sql1="CREATE TABLE library1(bname CHAR(15),bnum CHAR(15),bdate CHAR(15),"
+ "bauthor CHAR(15),"
+"bprice CHAR(15))";
String sql="INSERT INTO library1(bname,bnum,bdate,bauthor,bprice) "
+ "values(bname,bnum,bdate,bauthor,bprice)";
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(url);
stmt=con.createStatement();
stmt.executeUpdate(sql1);
stmt.executeUpdate(sql);
}
catch (Exception e) {
e.printStackTrace();
}
}
}
jsp输入的数据在Servlet中可以接收到并显示,但是无法再数据库中创建表格并插入数据,求指点。
数据库是用Navicat for MySQL连接的