sqljavabean.java

来自「这是个简单的在线书店购书系统」· Java 代码 · 共 80 行

package mybox;

import java.sql.*; 
import java.io.*; 

public class Sqljavabean{ 
private String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
private String url = "jdbc:microsoft:sqlserver://127.0.0.1;databaseName=lm";
private String name="sa";
private String password="sa";
private Connection conn = null; 
private ResultSet rs = null; 
private Statement stmt;
//注册数据库驱动程序 
public Sqljavabean() { 
try { 
Class.forName(sDBDriver); 
} 
catch(java.lang.ClassNotFoundException e) { 
System.err.println("chatreg(): " + e.getMessage()); 
} 
} 
//建立数据库连接及定义数据查询 

public ResultSet executeQuery(String sql) { 
rs = null; 
try { 
conn = DriverManager.getConnection(url,name,password); 
Statement stmt = conn.createStatement(); 
rs = stmt.executeQuery(sql); 
} 
catch(SQLException ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage()); 
} 
return rs; 
} 

//定义数据操作 
public void executeUpdate(String sql) 
{ 
Statement stmt=null; 
rs=null; 
try 
{ 
conn=DriverManager.getConnection(url,name,password); 
stmt=conn.createStatement(); 
stmt.executeUpdate(sql); 
stmt.close(); 
conn.close(); 

} 
catch (SQLException ex) 
{ 
System.err.println("executeUpdate:" + ex.getMessage()); 

} 
} 
//关闭数据库 
public void closeStmt() 
{ 
	try{ 
			stmt.close(); 
		} 
		catch (SQLException e) 
			{ 
			
			} 
} 

public void closeConn() 
{ 
		try{ 
				conn.close(); 
			} 
			catch (SQLException e) 
				{ 
				
				} 
	}
}