谁能给出一个连接sqlserver数据库的源码,谢 DBconn (): com.microsoft.jdbc.sqlserver.SQLServerDriverNo suitable driverPress any key to continue... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import java.sql.*;public class aaa { Connection conn = null; String strCon = "jdbc:microsoft:sqlserver://127.0.0.1\\test"; ResultSet rs = null; int iRow; ////////////////////////////构造函数////////////////////////// public aaa() { try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); }catch(java.lang.ClassNotFoundException e) { System.err.println("DBconn (): "+e.getMessage()); } }////////////////////////////对news表进行查询////////////////////////// public ResultSet executeQuery(String sql) { try { conn = DriverManager.getConnection(strCon); Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println( ex.getMessage()); } return rs; } ////////////////////////////对news表进行更新////////////////////////// public int executeUpdate(String sql) { iRow = 0; try { conn = DriverManager.getConnection(strCon); Statement stmt = conn.createStatement(); iRow = stmt.executeUpdate(sql); } catch(SQLException ex) { System.err.println("aq.executeUpdate: " + ex.getMessage()); } return iRow; } public static void main(String[] args) { aaa a=new aaa();String str1="select * from fabuhui ";ResultSet rs1=a.executeQuery(str1);try{if( rs1 != null ){ while(rs1.next()){ System.out.println(rs1.getString("title") + " "+rs1.getString("content")); }}}catch(Exception e){ System.err.println(e.getMessage()); } } }帮忙看看那错了? Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=pubs"; //pubs为你的数据库的 String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from test"; ResultSet rs=stmt.executeQuery(sql); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");String url="jdbc:odbc:name"; //name 为你的数据源名 Connection con=DriverManager.getConnection(url,"sa",""); Statement stat=con.CreateStatement();ResultSet rst = stat.executeQuery("Select * from test"); 先确认你的驱动的路径已经设到classpath里了。 [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.Press any key to continue...是怎么一会是亚 String strCon = "jdbc:microsoft:sqlserver://127.0.0.1\\test"; || || || || || || || || \ / \ / \ / \ / \/ \/ \/ \/jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=test 多线程并发求教 eclipse导入web工程 我就不信不得! 这是我用JAVA写的读磁盘扇区程序代码,在此抛砖引玉 String str=new String("abc");到底创建了几个对象?? 求助:在unix系统中使用jxl.jar读取Excel乱码问题? 请教个Applet问题 如何对一个文件中的内容逐字扫描? Java中怎么访问内存中的其它进程??? split问题! JAVA 事件监听类和线程同步的问题.(由于系统限制,本人愿再加300分) 【请求如何“让窗口永远固顶”!(没人给个明确答案)】 各位大虾帮忙看一下这段程序
import java.sql.*;
public class aaa {
Connection conn = null;
String strCon = "jdbc:microsoft:sqlserver://127.0.0.1\\test";
ResultSet rs = null;
int iRow;
//////////////////////////
//构造函数
//////////////////////////
public aaa() {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}catch(java.lang.ClassNotFoundException e) {
System.err.println("DBconn (): "+e.getMessage());
}
}//////////////////////////
//对news表进行查询
//////////////////////////
public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection(strCon);
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println( ex.getMessage());
}
return rs;
}
//////////////////////////
//对news表进行更新
//////////////////////////
public int executeUpdate(String sql) {
iRow = 0;
try {
conn = DriverManager.getConnection(strCon);
Statement stmt = conn.createStatement();
iRow = stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeUpdate: " + ex.getMessage());
}
return iRow;
}
public static void main(String[] args) {
aaa a=new aaa();
String str1="select * from fabuhui ";
ResultSet rs1=a.executeQuery(str1);
try{
if( rs1 != null ){
while(rs1.next()){
System.out.println(rs1.getString("title") + " "+rs1.getString("content"));
}
}
}catch(Exception e){
System.err.println(e.getMessage());
}
}
}
帮忙看看那错了?
String url="jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
Connection con=DriverManager.getConnection(url,"sa",""); Statement stat=con.CreateStatement();ResultSet rst = stat.executeQuery("Select * from test");
ey to continue...
是怎么一会是亚
|| || || ||
\ / \ / \ / \ /
\/ \/ \/ \/jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=test