servlet连接数据库实现注册

深藏阁楼爱情的钟 2023-06-20 10:52 2阅读 0赞

## servlet连接数据库实现注册 ##

配置数据库

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql:///test
    jdbc.user=root
    jdbc.pwd=123456

创建实体类

/**
     * 
     */
    package register;
    
    /**
     * @author xiao
     *
     */
    public class User {
        
            private int uid;
            private String uname;
            private String pwd;
    		public int getUid() {
        
    			return uid;
    		}
    		public void setUid(int uid) {
        
    			this.uid = uid;
    		}
    		public String getUname() {
        
    			return uname;
    		}
    		public void setUname(String uname) {
        
    			this.uname = uname;
    		}
    		public String getPwd() {
        
    			return pwd;
    		}
    		public void setPwd(String pwd) {
        
    			this.pwd = pwd;
    		}
    		@Override
    		public String toString() {
        
    			return "User [uid=" + uid + ", uname=" + uname + ", pwd=" + pwd + "]";
    		}
            
    }

连接数据库

package utils;
    
    import java.io.IOException;
    import java.io.InputStream;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.util.Properties;
    
    import javax.sql.DataSource;
    
    public class JdbcUtils {
        
    	public static final DataSource getConnection = null;
    	private static String driverClass;
    	private static String url;
    	private static String user;
    	private static String pwd;
    	
    	static {
        
    		//获取类加载器，目的读取配置文件
    		InputStream is = JdbcUtils.class.getClassLoader().getResourceAsStream("jdbc.properties");
    		
    		//使用Properties类
    		Properties prop = new Properties();
    		try {
        
    			prop.load(is);
    			driverClass = prop.getProperty("jdbc.driver");
    			url = prop.getProperty("jdbc.url");
    			user = prop.getProperty("jdbc.user");
    			pwd = prop.getProperty("jdbc.pwd");
    		} catch (IOException e) {
        
    			e.printStackTrace();
    		}
    		
    		//加载驱动
    		try {
        
    			Class.forName(driverClass);
    		} catch (ClassNotFoundException e) {
        
    			e.printStackTrace();
    		}
    	}
    	
    	
    	public static Connection getConnection() {
        
    		Connection conn = null;
    		try {
        
    			conn = DriverManager.getConnection(url,user,pwd);
    		} catch (SQLException e) {
        
    			e.printStackTrace();
    		}
    		return conn;
    	}
    	   public static void release(Connection conn, PreparedStatement ps, ResultSet rs) {
        
    	        try {
        
    	            if(rs != null) {
        
    	                rs.close();
    	            }
    	            if(ps != null) {
        
    	                ps.close();
    	            }
    	            if(conn != null) {
        
    	                conn.close();
    	            }
    	        } catch (Exception e) {
        
    	            e.printStackTrace();
    	        }
    	    }
    }

servlet实现方法

package register;
    
    import java.io.IOException;
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import org.apache.commons.dbutils.QueryRunner;
    import javafx.util.converter.DateStringConverter;
    import utils.JdbcUtils;
    
    /**
     * Servlet implementation class RegisterServlet
     */
    @WebServlet({
         "/RegisterServlet", "/register" })
    public class RegisterServlet extends HttpServlet {
        
    
           
    
    	protected void doGet(HttpServletRequest request, HttpServletResponse response ) throws ServletException, IOException {
        
            		String uname = request.getParameter("uname");
            		//       String uid = request.getParesponserameter("uid");
            		String pwd = request.getParameter("pwd");
            		String op=request.getParameter("op");
            		if ("login".equals(op)) {
        
    					regist(request,response);
    				}
                                                             
    	}
    	   //注册方法
        public void regist(HttpServletRequest request, HttpServletResponse response) {
        
        	
        	//获取网页上的注册信息
        	String uname=request.getParameter("uname");
        	String pwd =request.getParameter("pwd");
      
        	//操作数据库
        			Connection conn=null;
        			PreparedStatement ps=null;
        			int s=0;
        			try {
        
    					conn=JdbcUtils.getConnection();
    					String sql="insert into user(uname,pwd) values(?,?)";
    					ps=conn.prepareStatement(sql);
    					ps.setString(1, uname);
    					ps.setString(2, pwd);
    					s=ps.executeUpdate();
    				} catch (Exception e) {
        
    					e.printStackTrace();		
    				}finally {
        
    					JdbcUtils.release(conn, ps, null);
    				}
        			if(s>0) {
        
        				System.out.println("注册陈宫");
        			}
        }
    
    	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
    		// TODO Auto-generated method stub
    		doGet(request, response);
    	}
    
    }

jsp前台页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    <form action="RegisterServlet" method="post">
    <input type="hidden" name="op" value="login">
    用户名：<input type="text" name ="uname"><br/>
    密码：<input type="password" name ="pwd"><br/>
    <input type="submit" value="注册">
    </form>
    </body>
    </html>