import java.sql.*;public class Jsp1Bean {
Connection conn=null;
ResultSet rs=null;
Statement stat=null;
String classN="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;"+"DatabaseName=Mydata"; //localhost可改成你需要的IP+端口+database public Jsp1Bean(){
try{
Class.forName(classN);
conn=DriverManager.getConnection(url,"sa","123"); //sa:用户名; 123:密码
stat=conn.createStatement();
}catch(java.lang.ClassNotFoundException e){
System.err.println("faq():"+e.getMessage());
}catch(java.sql.SQLException e1){
System.out.println("faq():"+e1.getMessage());
}
}
//数据查询
public ResultSet executeQuery(String sql){
try{
conn=DriverManager.getConnection(url,"sa","123");
stat=conn.createStatement();
rs=stat.executeQuery(sql);
}catch(SQLException e3){
System.out.println("aq.executeQuery:"+e3.getMessage());
}
return rs;
}
//数据更新
public boolean executeUpdate(String sql1){
try{
stat.executeUpdate(sql1);
return true;
}catch(SQLException e4){
System.err.print("e4:"+e4.getMessage());
}
return false;
}
}
Connection conn=null;
ResultSet rs=null;
Statement stat=null;
String classN="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;"+"DatabaseName=Mydata"; //localhost可改成你需要的IP+端口+database public Jsp1Bean(){
try{
Class.forName(classN);
conn=DriverManager.getConnection(url,"sa","123"); //sa:用户名; 123:密码
stat=conn.createStatement();
}catch(java.lang.ClassNotFoundException e){
System.err.println("faq():"+e.getMessage());
}catch(java.sql.SQLException e1){
System.out.println("faq():"+e1.getMessage());
}
}
//数据查询
public ResultSet executeQuery(String sql){
try{
conn=DriverManager.getConnection(url,"sa","123");
stat=conn.createStatement();
rs=stat.executeQuery(sql);
}catch(SQLException e3){
System.out.println("aq.executeQuery:"+e3.getMessage());
}
return rs;
}
//数据更新
public boolean executeUpdate(String sql1){
try{
stat.executeUpdate(sql1);
return true;
}catch(SQLException e4){
System.err.print("e4:"+e4.getMessage());
}
return false;
}
}
http://www.microsoft.com/downloads/details.aspx?FamilyID=ee91ad1a-1ee4-49e1-95ea-e3f0e39114a9&DisplayLang=en
压缩后把msbase.jar,mssqlserver.jar, msutil.jar这三个文件拷贝到jre/lib/ext目录下,在环境变量classpath中也增加这三个文的路经
程序:例子
import java.sql.*;
class SqlTest{
public static void main(String args[]) throws ClassNotFoundException,SQLException{
String dburl="jdbc:microsoft:sqlserver://计算机IP:数据库端口;DatabaseName=数据库名";
String user="sa";
String password=""; //连接数据库的参数
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; //连接数据库的驱动程序
try{
Class.forName(driver); //装载数据库驱动程序
Connection c=DriverManager.getConnection(dburl,user,password); //得到与数据库连接
Statement s=c.createStatement(); //创建语句
ResultSet r=s.executeQuery("SELECT * FORM 表名");//查询数据库
while(r.next())
System.out.println(r.getString(1)) //输出数据第一个字段内容
}catch(ClassNotFoundException e){
System.out.println("驱动程序装载失败");
e.printStackTrace();
}catch(SQLException e){
System.out.println("与数据库连接失败");
e.printStackTrace();
}
}
}
如果你的程序输出 "驱动程序装载失败",那就表示你的驱动程序没有配置好
如果你的程序输出 "与数据库连接失败",表示你的数据库参数没有设好。
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );