62,615
社区成员
发帖
与我相关
我的任务
分享
import java.sql.*;
public class SqlServerTest {
/**
* @param args
*/
public static Connection connection() throws SQLException, ClassNotFoundException
{
Connection conn = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Beloria;uid = sa;pid=123");
return conn;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try
{
conn = connection();
System.out.println("Success!");
//PreparedStatement ps = conn.prepareStatement("select * from users");
//rs = ps.executeQuery();
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from users");
System.out.println(rs);
}
catch(Exception e)
{
System.out.println(e);
}
}
}
输出结果:
Success!
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]对象名 'users' 无效。
import java.sql.*;
public class SqlServerTest {
/**
* @param args
*/
public static Connection connection() throws SQLException, ClassNotFoundException
{
Connection conn = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Beloria;uid = sa;pid=123");
return conn;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try
{
conn = connection();
System.out.println("Success!"); //如果输出Success说明连接数据库成功
//PreparedStatement ps = conn.prepareStatement("select * from users");
//rs = ps.executeQuery();
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from users");
System.out.println(rs.getString(1)); //这里出现异常,如果改用System.out.println(rs);则输出sun.jdbc.odbc.JdbcOdbcResultSet@2e7263
//说明上面的查询语句没有抛出异常
}
catch(Exception e)
{
System.out.println(e);
}
}
}