sqldb.java

小型零售商店管理数据库管理

package retail;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class SqlDB {
	private static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
    private static String url = "jdbc:sqlserver://localhost:1433; DatabaseName=retail";  //连接服务器和数据库Retail
    private static Connection conn;
    private  static Statement comm;
    private static ResultSet rs;
    public static void regDriver(){
    	try{
    		Class.forName(driver).newInstance();
    	}
    	catch(Exception e){
    		System.out.println("无法创建驱动程序实体！");
    	}
    }
    public static void conBuild(){
    	try{
    	SqlDB.regDriver();
    	conn=DriverManager.getConnection(url,"sa","");
    	conn.setAutoCommit(true);
    	
    	}
    	catch(Exception e){
    		System.out.println(e.getMessage());
    		System.out.println("无法连接数据库Connection!");
    	}
    }
    public static ResultSet execQuery(String stmt){
    	try{
    		SqlDB.conBuild();
    		comm=conn.createStatement();
    		rs=comm.executeQuery(stmt);
    		return rs;
    	}
    	catch(Exception e){
    		System.out.println("无法创建Statement!");
    		return null;
    	}
    }
    public static void execUpdate(String UpdateString){
    	try{
    		SqlDB.conBuild();
    		comm=conn.createStatement();
    		rs=comm.executeQuery(UpdateString);
    	
    	}
    	catch(Exception e){
    		e.getMessage();
    	}
    }
    public static void closeDB(){
    	try{
    		comm.close();conn.close();
    	}catch(Exception e){
    		System.out.println(e.getMessage());
    	}
    }
    
}