dbconnbean.java~29~

Name: Book shop manager. 开发语言: Java

package bookmanager;

/**
 * <p>Title: 图书管理</p>
 *
 * <p>Description: 大型软件实习项目</p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 武汉大学计算机学院</p>
 *
 * @author 王佳
 * @version 1.0
 */
import java.sql.*;

public class dbconnBean {
    String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookdb";
    String user="sa";
    String password="19821216";
    Connection conn=null;
    Statement stmt=null;
    ResultSet rs=null;

    public dbconnBean() {
        try {
            Class.forName(dbDriver);
        } catch (ClassNotFoundException ex) {
            System.out.println("****************exception in dbconnBean:"+ex.getMessage()+"********************");
           // ex.printStackTrace();
        }
    }

    public boolean executeInsert(String sql){
        try{
            conn = DriverManager.getConnection(url, user, password);
            stmt = conn.createStatement();
            stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        }catch(Exception ex1){
            System.out.println("****************exception in dbconnBean:+++++[public boolean executeInsert(String sql)]"+ex1.getMessage()+"********************");
           // ex1.printStackTrace();
            return false;
        }
        return true;
    }

    public ResultSet executeQuery(String sql){
        try{
            conn=DriverManager.getConnection(url,user,password);
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs=stmt.executeQuery(sql);
        }catch(Exception ex2){
            System.out.println("****************exception in dbconnBean:+++++[public ResultSet executeQuery(String sql)]"+ex2.getMessage()+"********************");
            //ex2.printStackTrace();
        }
        return rs;
    }

    public boolean executeUpdate(String sql){
        try{
            conn = DriverManager.getConnection(url, user, password);
            stmt = conn.createStatement();
            stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        }catch(Exception ex3){
            System.out.println("****************exception in dbconnBean:+++++[public boolean executeUpdate(String sql)]"+ex3.getMessage()+"********************");
            //ex3.printStackTrace();
            return false;
        }
        return true;
    }

    public boolean executeDelete(String sql){
        try{
            conn = DriverManager.getConnection(url, user, password);
            stmt = conn.createStatement();
            stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        }catch(Exception ex4){
            System.out.println("****************exception in dbconnBean:+++++[public boolean executeDelete(String sql)]"+ex4.getMessage()+"********************");
           // ex4.printStackTrace();
            return false;
        }
        return true;
    }

    public void closeStmt(){
        try{
            stmt.close();
        }catch(Exception ex5){
            System.out.println("****************exception in dbconnBean:+++++[ public void closeStmt()]"+ex5.getMessage()+"********************");
           // ex5.printStackTrace();
        }
    }

    public void closeConn(){
        try{
            conn.close();
        }catch(Exception ex6){
            System.out.println("****************exception in dbconnBean:+++++[public void closeConn()]"+ex6.getMessage()+"********************");
           // ex6.printStackTrace();
        }
    }




public static void main(String[] args) {
        dbconnBean dbconnbean = new dbconnBean();
        ResultSet res=dbconnbean.executeQuery("select * from bookuser where username='ivan0385' and password = 'ivan0385'");
        try{
            while (res.next()) {
                System.out.print(res.getLong("uid"));
            }
        }catch(Exception e){}
   }
}