Java JDBC sqlserver连接（增删改）方法二

jdbc驱动包要网上下载

sqljdbc4.jar

sqljdbc_4.0.rar

所有的import包要放到   项目目录下的\WebContent\WEB-INF\lib里

//Initialization.java

package szy.shopping.dao;

import java.sql.Connection;
import java.sql.DriverManager;

public class Initialization {
	private Connection con;
	
	public Initialization(){
		con=null;
	}
	//初始化
	public  Connection init(){
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=shoppingDB","sa","xxx");
		} catch (Exception e) {
			System.out.println("CustomerDAO.init ERROR ## "+e.getMessage());
		}
		return con;
	}
}

//AdminDAO.java

package szy.shopping.dao;

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

import szy.shopping.entity.Admin;

public class AdminDAO {
	Connection con;
	PreparedStatement pstm;
	ResultSet rs;
	
	public AdminDAO(){
		Initialization initialization=new Initialization();
		con=initialization.init();
	}
	//查询管理员密码是否正确
	public boolean checkAdmin(Admin admin){
		boolean result=false;
		try {
			pstm=con.prepareStatement("select * from Admin where userName=? and password=?");
			pstm.setObject(1, admin.getUserName());
			pstm.setObject(2, admin.getPassword());
			rs=pstm.executeQuery();
			if(rs.next())  //存在结果
				result=true;
			destroy();
		} catch (Exception e) {
			System.err.println("AdminDAO.checkAdmin ERROR ## "+e.getMessage());
		}
		return result;
	}
	//修改密码
	public boolean changePassword(String userName,String newPassword){
		boolean result=false;
		try {
			pstm=con.prepareStatement("update admin set password=? where userName=?");
			pstm.setObject(1, newPassword);
			pstm.setObject(2, userName);
			pstm.execute();
			result=true;
			destroy();
		} catch (Exception e) {
			System.err.println("AdminDAO.changePassword ERROR ## "+e.getMessage());
		}
		return result;
	} 
	//添加新客户
	public boolean addNewAdmin(Admin admin){
		boolean result=false;
		try {
			pstm=con.prepareStatement("insert into Admin values(?,?)");
			pstm.setObject(1, admin.getUserName());
			pstm.setObject(2, admin.getPassword());
			pstm.execute();
			result=true;
			destroy();
		} catch (Exception e) {
			System.err.println("AdminDAO.addNewAdmin ERROR ## "+e.getMessage());
		}
		return result;
	}
	
	//释放资源
	private void destroy(){
		try {
			if(rs!=null){
				rs.close();
			}
			if(pstm!=null){
				pstm.close();
			}
			if(con!=null){
				con.close();
			}
		} catch (Exception e) {
			System.out.println("CustomerDAO.destroy ERROR ## "+e.getMessage());
		}
	}
//	
//	public static void main(String[] args) {
//		//AdminDAO admin=new AdminDAO();
//		//System.out.println(admin.checkAdmin("admin", "admin"));
//		//System.out.println(admin.changePassword("admin", "admin"));
//		//System.out.println(admin.addNewAdmin("coolszy", "kuka"));
//	}
	
}