1.装jdk
2.装eclipse
3.装sql (登陆设置为: SQL Server 和 Windows 身份验证模式)
4.装sql补丁
5.装数据库驱动包把(msbase.jar mssqlserver.jar msutil.jar)拷贝到java如目录:(C:/Program Files/Java/jre1.6.0_07/lib/ext)目录下
测试代码如下:
import java.sql.*;
public class DBCon{
String strurl="jdbc:odbc:coursetable";
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
String user="sa";
String password="";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public DBCon()
{
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("opendb(): " + e.getMessage());
}
}
// 返回数据库连接对象
public Connection Creatconn(){
conn = null;
try{
conn=DriverManager.getConnection(sConnStr,user,password);
return conn;
}
catch(Exception fe){
System.err.println("Creatconn(): " + fe.getMessage());
return null;
}
}
// 返回状态集对象
public Statement CreatStat(){
stmt = null;
try{
conn=this.Creatconn();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
return stmt;
}
catch(Exception fe){
System.err.println("CreatStat(): " + fe.getMessage());
return null;
}
}
// 返回记录集对象
public ResultSet getResult(String sql){
//rs = null;
try{
stmt = this.CreatStat();
rs = stmt.executeQuery(sql);
return rs;
}
catch(SQLException ex){
System.err.println("getResult: " + ex.getMessage());
return null;
}
}
//执行更新 删除语句
public boolean executeSql(String sql)
{
try{
stmt=this.CreatStat();
stmt.executeUpdate(sql);
conn.commit();
return true;
}
catch(Exception e)
{
System.err.println("exectueSql: "+e.toString());
return false;
}
}
}
import java.sql.*;
import java.sql.ResultSet;
import java.sql.SQLException;
class testDB {
public static void main(String args[]){
DBCon con=new DBCon();
String sql="select * from jobs";
Connection cn= con.Creatconn();
System.out.println("数据库对象");
Statement st=con.CreatStat();
System.out.println("打开数据库");
ResultSet rs=con.getResult(sql);
System.out.println("数据集");
try{
while(rs.next())
{
System.out.println(rs.getString(1)+rs.getString(2));
}
}
catch(Exception e){
e.printStackTrace();
}
}
}