Tomcat 连接MySQL

使用JDBC连接数据库主要由以下几个动作组成：

1. 加载JDBC驱动程序

2. 连接数据库

3. 操作数据库

4. 关闭数据库连接

//*****RegisterServlet.java******* 
//完成用户自助注册任务。将用户名，密码，邮箱等信息保存至MySQL数据库,参数传入由JSP文件SelfRegister.jsp完成。
  
　1 import java.io.IOException;
  2 import java.io.PrintWriter;
  3 import java.sql.Connection;
  4 import java.sql.DriverManager;
  5 import java.sql.SQLException;
  6 import java.sql.Statement;
  7 
  8 import javax.servlet.RequestDispatcher;
  9 import javax.servlet.ServletException;
 10 import javax.servlet.annotation.WebServlet;
 11 import javax.servlet.http.HttpServlet;
 12 import javax.servlet.http.HttpServletRequest;
 13 import javax.servlet.http.HttpServletResponse;
 14 
 15 /**
 16  * Servlet implementation class RegisterServlet
 17  */
 18 @WebServlet("/RegisterServlet")
 19 public class RegisterServlet extends HttpServlet {
 20     private static final long serialVersionUID = 1L;
 21        
 22     /**
 23      * @see HttpServlet#HttpServlet()
 24      */
 25     public RegisterServlet() {
 26         super();
 27         // TODO Auto-generated constructor stub
 28     }
 29 
 30     /**
 31      * @see HttpServlet#service(HttpServletRequest request, HttpServletResponse response)
 32      */
 33     protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 34         // TODO Auto-generated method stub
 35         String DBDRIVER = "com.mysql.jdbc.Driver";
 36         String DBURL = "jdbc:mysql://localhost:3306/test";
 37         String DBUSER = "root";
 38         String DBPASS = "sap123";
 39         
 40         Connection con = null;
 41         Statement stmt = null;  
 42         String username = request.getParameter("username");
 43         String password = request.getParameter("pass");
 44         String email = request.getParameter("email");
 45         
 46         if(username != null )
 47         {
 48             try {
 49                 Class.forName(DBDRIVER);
 50             } catch (ClassNotFoundException e) {
 51                 // TODO Auto-generated catch block
 52                 e.printStackTrace();
 53             } 
 54             try {
 55                 con = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
 56             } catch (SQLException e) {
 57                 // TODO Auto-generated catch block
 58                 e.printStackTrace();
 59             }
 60             
 61             try {
 62                 stmt = con.createStatement();
 63             } catch (SQLException e1) {
 64                 // TODO Auto-generated catch block
 65                 e1.printStackTrace();
 66             } 
 67             
 68             
 69             
 70              
 71             try {
 72                 stmt.executeUpdate("insert into userData values('" + username + "','" + password +"','"+ email +"')");
 73             } catch (SQLException e1) {
 74                 // TODO Auto-generated catch block
 75                 e1.printStackTrace();
 76             } 
 77             
 78             
 79             try {
 80                 con.close();
 81             } catch (SQLException e) {
 82                 // TODO Auto-generated catch block
 83                 e.printStackTrace();
 84             }
 85             
 86             
 91         }
 92         
 93         
 94         
 95         RequestDispatcher rd;
 96         
 97         rd = request.getRequestDispatcher("/LoginPage.jsp");
 98         try {  
 99             rd.forward(request, response);  
100                  return;  
101         }catch(Exception e){}
102         
103         //response.sendRedirect("http://www.baidu.com");
104         //response.sendRedirect("/Login/LoginPage.jsp");
105     }
106 
107 }

 JSP页面：

 1 <html>
 2 <head>
 3 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
 4 <title>Self Register Page</title>
 5 </head>
 6 <body>
 7 Hello and welcome to register yourself. <br>
 8 
 9 <form id="register" method="post" action="RegisterServlet">
10     User name <input type="text" name="username"  /> <br>
11     Password &nbsp  <input type="password" name="pass" /> <br>
12     Confirm password <input type="password" name="pass" /> <br>
13     Email adress <input type="text" name="email"  /> <br>
14     <input type="submit" value="Register"/> <br>
15     <br>
16     
17 </form>
18 
19 </body>
20 </html>

 

posted on 2014-07-06 20:30  westlifegc  阅读(538)  评论(0)    收藏  举报

导航