程序代码如下:
import java.sql.*;
import java.lang.Class;public class JDBCtest
{
public static void main(String[] args)
{
Connection conn = null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection ("jdbc:microsoft:sqlserver: //localhost:1433;DatabaseName=mydb;User=sa;Password=sa");
String sql = "select * from db_user";
PreparedStatement pstmt = conn.prepareStatement(sql);
//pstmt.setString(1,username);
ResultSet rs = pstmt.executeQuery();
while(rs.next())
{
System.out.println(rs.getString(1) + ",");
System.out.println(rs.getString(2) + ",");
System.out.println();
}
}catch(ClassNotFoundException e)
{
System.out.println("hehe");
}catch(SQLException ex)
{
System.out.println("haha");
ex.printStackTrace();
}
}
}运行时的错误:
haha
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at JDBCtest.main(JDBCtest.java:12)
Press any key to continue...不知道哪里出问题了,请高手看一下啊
import java.sql.*;
import java.lang.Class;public class JDBCtest
{
public static void main(String[] args)
{
Connection conn = null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection ("jdbc:microsoft:sqlserver: //localhost:1433;DatabaseName=mydb;User=sa;Password=sa");
String sql = "select * from db_user";
PreparedStatement pstmt = conn.prepareStatement(sql);
//pstmt.setString(1,username);
ResultSet rs = pstmt.executeQuery();
while(rs.next())
{
System.out.println(rs.getString(1) + ",");
System.out.println(rs.getString(2) + ",");
System.out.println();
}
}catch(ClassNotFoundException e)
{
System.out.println("hehe");
}catch(SQLException ex)
{
System.out.println("haha");
ex.printStackTrace();
}
}
}运行时的错误:
haha
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at JDBCtest.main(JDBCtest.java:12)
Press any key to continue...不知道哪里出问题了,请高手看一下啊
解决方案 »
- 啊啊 用MyEclipse自动生成的菜单项单击事件处理不能用,求救
- 怎样在java程序中控制内存的使用,比如一个程序要用大量的内存,怎么控制
- 请问怎么将OpenJMS 邦定到 tomcat 上
- 如何将一个txt文件,读取到一个String数组里面
- 一个finally和return的题,请大家帮忙看看
- 关于java数据库的一个问题,知道的请回答一下
- 做程序员到底后悔吗 请留下您的意见 谢谢
- 关于应聘JAVA网络编成时笔试的问题(散分)
- 能不能帮个忙
- 这段代码为什么我无法通过输入框把二进制的数字输出的?求大神们支教
- 问个jsp显示数据库内容的问题
- 如何使用AWT显示一张在InputStream中的图片?
jdbc:microsoft:sqlserver: //localhost:1433;中间多了个空格