database.java

java链接SQL Server数据库及响应操作的一段代码

package data;
import java.io.*;
import java.sql.*;
public class dataBase{
public Connection conn=null;
public ResultSet rs=null;
public String sqlName="teach";
public String userName="sa";
public String keyWord="023854";

 String DatabaseDriver="net.sourceforge.jtds.jdbc.Driver";
 String url="jdbc:jtds:sqlserver://localhost:1433/teach";

public dataBase(){
	try{
	Class.forName(DatabaseDriver);
             conn=DriverManager.getConnection(url,userName,keyWord);
}

catch(java.lang.ClassNotFoundException e){
	System.err.println("加载驱动有误:"+e.getMessage());
	System.out.print(e.getMessage());
}
catch(SQLException ex){
	System.err.println("加载驱动有误:"+ex.getMessage());
	System.out.print(ex.getMessage());
}
}

public void executeUpdate(String sql){
	try{
	conn=DriverManager.getConnection(url,userName,keyWord);
	Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
	stmt.executeUpdate(sql);
}
catch(SQLException ex){
	System.err.println("加载驱动有误:"+ex.getMessage());
	System.out.print(ex.getMessage());
}
}

public void executeDelete(String sql){
	try{
	conn=DriverManager.getConnection(url,userName,keyWord);
	Statement stmt=conn.createStatement();
	stmt.executeUpdate(sql);
}
catch(SQLException ex){
	System.err.println("加载驱动有误:"+ex.getMessage());
	System.out.print(ex.getMessage());
}
}

public ResultSet executeQyery(String sql){
	rs=null;
	try{
	conn=DriverManager.getConnection(url,userName,keyWord);
	Statement stmt=conn.createStatement();
	rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
	System.err.println("加载驱动有误:"+ex.getMessage());
	System.out.print(ex.getMessage());
}
return rs;
}

public void CloseDataBase(){
	try{
	conn.close();
}
catch(Exception end){
	System.err.println("加载驱动有误:"+end.getMessage());
	System.out.print(end.getMessage());
	
}
}
}