java代码070

code070.java

1package pack02;
2
3import java.io.IOException;
4import java.io.PrintWriter;
5import java.sql.Connection;
6import java.sql.DriverManager;
7import java.sql.PreparedStatement;
8
9import javax.servlet.ServletConfig;
10import javax.servlet.ServletException;
11import javax.servlet.annotation.WebServlet;
12import javax.servlet.http.HttpServlet;
13import javax.servlet.http.HttpServletRequest;
14import javax.servlet.http.HttpServletResponse;
15
16//SaveServlet��
17@WebServlet(name = "code070",urlPatterns = "/page04/code070")
18public class code070 extends HttpServlet
19{
20	private Connection conn = null;
21	
22	@Override
23	public void init(ServletConfig config) throws ServletException
24	{
25		//��ʼ��ʱ�������ݿ⽨������
26		String driver = "com.mysql.jdbc.Driver";
27		String url = "jdbc:mysql://localhost:3306/test";
28		String user = "root";
29		String password = "mysql123";
30		try
31		{
32			Class.forName(driver);
33			this.conn = DriverManager.getConnection(url,user,password);
34			if (this.conn != null)
35			{
36				System.out.println("���ݿ����ӳɹ���");
37			}
38		} catch (Exception e)
39		{
40			e.printStackTrace();
41		}
42		
43	}
44	
45	@Override
46	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
47	{
48		response.setContentType("text/html");
49		request.setCharacterEncoding("utf-8");
50		response.setCharacterEncoding("utf-8");
51		
52		String userName = request.getParameter("userName");
53		String pwd = request.getParameter("pwd");
54		String sex = request.getParameter("sex");
55		String description = request.getParameter("description");
56		if (conn != null)
57		{
58			try
59			{
60				String sql = "insert into user(user_name,password,sex,description)"
61				+ "values(?,?,?,?)";
62			 	PreparedStatement param = conn.prepareStatement(sql);
63				param.setString(1, userName);
64				param.setString(2, pwd);
65				param.setString(3, sex);
66				param.setString(4, description);
67				param.executeUpdate();
68				
69				PrintWriter writer1 = response.getWriter();
70				writer1.print("<h1>");
71				writer1.print(userName + "ע��ɹ�");
72				writer1.print("</h1>");
73				writer1.flush();
74				writer1.close();
75				conn.close();
76			} catch (Exception e)
77			{
78				e.printStackTrace();
79			}
80		}
81		else 
82		{
83			response.sendError(500,"���ݿ����Ӵ���");
84		}
85	}
86}
87
88
89/*
90 *servlet3.0������
91 *����ע����servlet3.0���ش����֮һ��
92 *ͨ��ʹ��ע�;�������web.xml�ļ��ж�servlet���߹�����
93 *���������ˡ�
94 *����ע����@WebServlet��@WebFilter��@WebListener��@WebInitParam
95 * 
96 * @WebServlet���������£�
97 * name string		�ȼ���<servlet-name>  
98 * value string[]  �ȼ��� urlPatterns ����������ͬʱʹ��
99 * urlPatterns string[] 	�ȼ���<url-pattern>
100 * loadOnStartup int 	�ȼ���<load-on-startup>
101 * initParams WebInitParam[]	�ȼ���<init-param>
102 * asyncSupported boolean	�ȼ���<async-supported>
103 * description sring	�ȼ���<description>
104 * displayName string  	�ȼ���<display-name>
105 */
106