import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;import com.sun.corba.se.pept.transport.Connection;public class jdbc {
public static void main(String[] args)throws Exception {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
String sql="select*from Student";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn= (Connection) DriverManager.getConnection("jdbc:odbc:mytest", "sa",
"198908263033");
ps = ((java.sql.Connection) conn).prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3)+"\t");
}
}catch (Exception e) {
e.printStackTrace();
} finally { try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
if (conn != null) {
conn.close();
} } catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}}
提示 加粗处 有问题
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;import com.sun.corba.se.pept.transport.Connection;public class jdbc {
public static void main(String[] args)throws Exception {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
String sql="select*from Student";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn= (Connection) DriverManager.getConnection("jdbc:odbc:mytest", "sa",
"198908263033");
ps = ((java.sql.Connection) conn).prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3)+"\t");
}
}catch (Exception e) {
e.printStackTrace();
} finally { try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
if (conn != null) {
conn.close();
} } catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}}
提示 加粗处 有问题
import java.sql.Connection;
用IDE开发导入类得时候一定要注意,不要导错了
嗯 已经解决了 就是那个 IDE工具的是 我换成java.sql.Connection 就没事了 谢谢