jdbcservletexample.java

解压在c盘

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JDBCServletExample extends HttpServlet
{
	private Connection con;
	public void init() throws ServletException
	{
		super.init();
		try{
			//String driveName="com.mysql.jdbc.Driver";
		//	String userName="root";
			//密码
			String userPasswd="";
			//数据库名
			//String dbName="text";
			//表名
			//String tableName="person";
			//连接字符串
			//String url="jdbc:mysql://localhost:3306/text?user=root&passwoed="";
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			//获取连接，放入成员变量con
			con=DriverManager.getConnection("jdbc:mysql://localhost:3306/text?user=root&passwoed="+userPasswd);
	    	}
		
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void service(HttpServletRequest rq,HttpServletResponse rp)throws ServletException,IOException
	{
		//读取前端From提交的参数
		String name=rq.getParameter("name");
		String sex=rq.getParameter("sex");
		String birthday=rq.getParameter("birthday");
		String email=rq.getParameter("email");
		String reg="insert into person values(?,?,?,?)";
		try{
			PreparedStatement stmt=con.prepareStatement(reg);
			stmt.setString(1,name);
			stmt.setString(2,sex);
			stmt.setString(3,birthday);
			stmt.setString(4,email);
			stmt.executeUpdate();
			System.out.println("insert ok");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
}