html前端数据写入mysql_html,jquery,ajax,servlet,mysql实现前端数据写入数据库

packagecom.jquery.register;importjava.io.IOException;importjava.io.PrintWriter;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;public class add extendsHttpServlet {public voiddestroy() {super.destroy();

}public voiddoGet(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException {

doPost(request,response);

}public voiddoPost(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException {

response.setContentType("text/html");

PrintWriter out=response.getWriter();

request.setCharacterEncoding("utf-8");

response.setCharacterEncoding("utf-8");

Connection conn= null;

PreparedStatement stmt= null;

ResultSet rs= null;

String name=request.getParameter("name");

String password=request.getParameter("password");

String drive= "com.mysql.jdbc.Driver";

System.out.println("ajax后台交互成功");try{

Class.forName(drive);

conn=DriverManager

.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=123");

System.out.println("数据库连接成功");

String sql="insert into user_table(name,password)";

sql+=" values(?,?)";

stmt=conn.prepareStatement(sql);

stmt.setString(1,name);

stmt.setString(2,password);

stmt.executeUpdate();

System.out.println("success");//out.flush();//out.close();

}catch(ClassNotFoundException e) {

e.printStackTrace();

}catch(SQLException e) {

e.printStackTrace();

}finally{try{//注意关闭原则：从里到外

if (rs != null) {

rs.close();

}if (stmt != null) {

stmt.close();

}if (conn != null) {

conn.close();

}

}catch(SQLException e) {

e.printStackTrace();

}

}

}public void init() throwsServletException {//Put your code here

}

}