62,614
社区成员
发帖
与我相关
我的任务
分享
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class dbconnect
{
public static void main(String args[])
{
String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";//声明数据库驱动JDBC-ODBC和ODBC驱动程序
String driver = "jdbc:odbc:MyJavaSQL";//声明数据源
//先连接,再state,然后result
Connection con = null;//声明连接对象
Statement stmt = null;//声明Statement对象
ResultSet rs = null;//声明返回结果对象
try
{
Class.forName(dbDriver);//装载驱动器
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("ClassNotFoundExcetion:"+e.getMessage());
}
try
{
con = DriverManager.getConnection(driver);//连接数据源
con.setAutoCommit(true);//允许自动调制
stmt = con.createStatement();//创建state
//sql语句的查询结果保存在rs里面
rs = stmt.executeQuery("select* from Student");//result存储结果
System.out.println("学号 "+" 姓名"+" "+"性别"+" "+"年龄"+" 系别");
while(rs.next())
{
String st1 = rs.getString(1);
String st2 = rs.getString(2);
String st3 = rs.getString(3);
int st4 = rs.getInt(4);
String st5 = rs.getString(5);
System.out.println(st1+st2+" "+st3+" "+st4+" "+st5);
}
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.err.println("SQLException:"+ex.getMessage());
}
}
}