一共3个函数 一个连接数据库的 一个检索数据库的 ,一个testpackage sqlcommon;import java.sql.Connection;
import java.sql.DriverManager;public class Mssql { /**
* @param args
*/
public Connection openDB() { String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user = "cjik";
String password = "111111"; try {
Class.forName(driver).newInstance();
Connection conn = DriverManager.getConnection(url, user, password);
return conn;
} catch (Exception e) {
e.printStackTrace();
return null;
} } public void close(Connection conn) { try {
if (conn != null && conn.isClosed() == false) {
conn.close();
} else if (conn == null || conn.isClosed() == true) {
return;
}
} catch (Exception e) {
e.printStackTrace();
} }
}
package sqlcommon;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;public class SelectData { /**
* @param args
*/
private Statement stm; private ResultSet rs; public void doSelect(String sql) {
try {
Mssql msconn = new Mssql();
Connection conn = msconn.openDB();
stm = conn.createStatement(
java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
rs = stm.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(1) + ":" + rs.getString(2)
+ ":" + rs.getString(3));
}
rs.close();
msconn.close(conn); } catch (Exception e) {
System.err.println("db.executeQuery: " + e.getMessage());
}
} public static void main(String[] args) {
// TODO 自动生成方法存根 }
}package sqlcommon;public class Testsql { /**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根
String s = "select * from test";
SelectData sd = new SelectData();
sd.doSelect(s);
}}报错内容是:java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at sqlcommon.Mssql.openDB(Mssql.java:22)
at sqlcommon.SelectData.doSelect(SelectData.java:20)
at sqlcommon.Testsql.main(Testsql.java:13)
db.executeQuery: null
import java.sql.DriverManager;public class Mssql { /**
* @param args
*/
public Connection openDB() { String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user = "cjik";
String password = "111111"; try {
Class.forName(driver).newInstance();
Connection conn = DriverManager.getConnection(url, user, password);
return conn;
} catch (Exception e) {
e.printStackTrace();
return null;
} } public void close(Connection conn) { try {
if (conn != null && conn.isClosed() == false) {
conn.close();
} else if (conn == null || conn.isClosed() == true) {
return;
}
} catch (Exception e) {
e.printStackTrace();
} }
}
package sqlcommon;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;public class SelectData { /**
* @param args
*/
private Statement stm; private ResultSet rs; public void doSelect(String sql) {
try {
Mssql msconn = new Mssql();
Connection conn = msconn.openDB();
stm = conn.createStatement(
java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
rs = stm.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(1) + ":" + rs.getString(2)
+ ":" + rs.getString(3));
}
rs.close();
msconn.close(conn); } catch (Exception e) {
System.err.println("db.executeQuery: " + e.getMessage());
}
} public static void main(String[] args) {
// TODO 自动生成方法存根 }
}package sqlcommon;public class Testsql { /**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根
String s = "select * from test";
SelectData sd = new SelectData();
sd.doSelect(s);
}}报错内容是:java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at sqlcommon.Mssql.openDB(Mssql.java:22)
at sqlcommon.SelectData.doSelect(SelectData.java:20)
at sqlcommon.Testsql.main(Testsql.java:13)
db.executeQuery: null
楼主【thinkhejie】截止到2008-07-24 14:34:34的历史汇总数据(不包括此帖):
发帖的总数量:9 发帖的总分数:190 每贴平均分数:21
回帖的总数量:7 得分贴总数量:1 回帖的得分率:14%
结贴的总数量:9 结贴的总分数:190
无满意结贴数:1 无满意结贴分:20
未结的帖子数:0 未结的总分数:0
结贴的百分比:100.00% 结分的百分比:100.00%
无满意结贴率:11.11 % 无满意结分率:10.53 %
敬礼!
sqljdbc.jar
sqljdbc_auth.dll
这两个文件要加到项目里面去,我都加了可还是不行了。。
我添加了哦