registerdao.java

jsp+servlet经典的登录注册

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class RegisterDAO {
	
	String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=student";
	Connection conn = null;
	PreparedStatement pst = null;
	ResultSet rs = null;
	
	public RegisterDAO(){
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	} 
	
	public int AddRegister(String sql,String userName,String sex,String passWord,String Email,String Card,String QQ,String Birthday){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			//RegisterBean register = new RegisterBean();
			pst.setString(1,userName);
			pst.setString(2,sex);
			pst.setString(3,passWord);
			pst.setString(4,Email);
			pst.setString(5,Card);
			pst.setString(6,QQ);
			pst.setString(7,Birthday);
			n = pst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
				try {
					if(pst != null){
						pst.close();
					}
					if(conn != null){
						conn.close();
					}
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		return n;
	}
	
	public int CheckPesson(String sql,String userName,String passWord){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setString(1, userName);
			pst.setString(2, passWord);
			rs = pst.executeQuery();
			
			if(rs.next()){
				n = rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
			try {
				if(rs != null){
					rs.close();
				}
				if(pst != null){
					pst.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return n;
	}
	
	public int CheckName(String sql,String userName){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst =  conn.prepareStatement(sql);
			pst.setString(1, userName);
			rs = pst.executeQuery();
			if(rs.next()){
				n = rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
			try {
				if(rs != null){
					rs.close();
				}
				if(pst != null){
					pst.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		
		
		}
		return n;
	}
}