jsp连接 sql server 的问题（谁是高手请指教一下）
我用jsp连接server 的时候出现一些问题请指教啊？
import java.sql.*;
public class DBTest
{
Connection con;
Statement sta;
ResultSet rs;
String driver;
String url;
String user;
String pwd;
public DBTest()
{
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";;
url = "jdbc:microsoft:sqlserver: //192.168.0.103:1433;DatabaseName =pubs";
//test为数据库名
user = "sa";
pwd = "";
//请更改为你相应的用户和密码
init();
}
public void init()
{
try{
Class.forName(driver);
System.out.println("driver is ok");
con = DriverManager.
getConnection(url,user,pwd);
System.out.println("conection is ok");
sta = con.createStatement();
rs = sta.executeQuery
("select * from jobs");
while(rs.next())
System.out.println
(rs.getInt("roomNum"));
}catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String args[])
//自己替换［］
{
new DBTest();
}
}
调试的时候出现一下问题？
driver is ok
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to conn
ect. Invalid URL.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at DBTest.init(DBTest.java:30)
at DBTest.<init>(DBTest.java:23)
at DBTest.main(DBTest.java:48)
问题点数：20、回复次数：4Top
1 楼yushihai（于世海）回复于 2006-05-03 09:44:16 得分 0
你可以这样写：
public DBTest()
{
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";;
url = "jdbc:microsoft:sqlserver: //192.168.0.103:1433;DatabaseName =pubs";
//test为数据库名
user = "sa";
pwd = "";
//请更改为你相应的用户和密码
try{
Class.forName(driver);
System.out.println("driver is ok");
con = DriverManager.
getConnection(url,user,pwd);
System.out.println("conection is ok");
sta = con.createStatement();
rs = sta.executeQuery
("select * from jobs");
while(rs.next())
System.out.println
(rs.getInt("roomNum"));
}catch(Exception e)
{
e.printStackTrace();
}
}
要不然它找不到URLTop
2 楼hyg17303（落叶）回复于 2006-05-03 10:29:00 得分 0
兄弟你少抛一个SQLException异常啊
try{ Class.forName(driver);
System.out.println("driver is ok");
}catch(ClassNotFoundException ce){}
接上面的一段再抓一个
try{...}catch(SQLException se){}Top
3 楼zifeng858858（）回复于 2006-05-04 03:14:51 得分 0
还是不行啊
问题是同样的
你们在帮忙看一下啊 谢谢Top
4 楼stevensinclair（向PM前进）回复于 2006-05-04 03:35:55 得分 0
import java.sql.*;
public class DBTest
{
Connection con;
Statement sta;
ResultSet rs;
String driver;
String url;
String user;
String pwd;
public DBTest()
{
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";;
url = "jdbc:microsoft:sqlserver: //192.168.0.103:1433;DatabaseName =pubs"; //192.168.0.103应该为你的服务器的名称.这里改里就对了
//pubs为数据库名
user = "sa";
pwd = "111111";//你的数据库密码
//请更改为你相应的用户和密码
init();
}
public void init()
{
try{
Class.forName(driver);
System.out.println("driver is ok");
con = DriverManager.
getConnection(url,user,pwd);
System.out.println("conection is ok");
sta = con.createStatement();
rs = sta.executeQuery
("select * from jobs");
while(rs.next())
System.out.println
(rs.getInt("roomNum"));
}catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String args[])
{
new DBTest();
}
}
好了.
楼主记得给分哦.
再不行发我邮件
loveseass@126.com标题注明csdn
Top
