Java数据库操作-----出现错误

来源:互联网 发布:linux下system函数 编辑:程序博客网 时间:2024/05/16 16:20
package com.pak;
import java.sql.*;








public class DB_1 
{


public static void main(String[] args)
{

Statement stmt=null;
Connection con=null;
ResultSet rs=null;
String url="jdbc.odbc:127.0.0.1:1433/kaoshi";
String sql="select *from ta_sdb";

try {
Class.forName("sun.jdbc:odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:kaoshi","sa","411628");
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{
int pk_sdbh=(int)rs.getInt(1);

String conent=rs.getString(2);
String sdmc=rs.getString(3);
String lxdh=rs.getString(4);
String fzr=rs.getString(5);


System.out.println("现在开始读取数据库内容");

System.out.println(pk_sdbh);
System.out.println(conent);
System.out.println(sdmc);
System.out.println(lxdh);
System.out.println(fzr);


}

} catch (Exception  e) {
// TODO Auto-generated catch block
e.printStackTrace();

finally
{
try {
if(stmt!=null)
{
stmt.close();
}
if(rs!=null)
{
rs.close();
}


} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}




}


}
0 0
原创粉丝点击