package DatabaseT;
import java.sql.*;
public class connectionDatabase {
public static void main(String[] args) {
Connection ct = null;
ResultSet rs = null;
PreparedStatement ps = null;
try {
//1,加载驱动
Class.forName("sun.jdbc.odbc.JdbcodbcDriver");
//2建立连接
ct = DriverManager.getConnection("jdbc:odbc:数据源名字", "数据库账号","密码");
//3,创建prepareStatement
//查询语句
ps = ct.prepareStatement("select * from 数据表 where id = ?");
//1代表第一个问号,2代表 想查找的id号
ps.setInt(1, 2);
rs = ps.executeQuery();
//更新语句,删除语句,插入语句同。
//ps.executeLargeUpdate("");
//rs游标指向下一行
while(rs.next()) {
System.out.println(rs.getInt(1) + " " + rs.getString(2) + " " +rs.getString(3));
}
} catch (Exception e) {
e.printStackTrace();
}
finally {
//关闭资源,后获取先关闭原则
try {
if(rs != null) {rs.close();}
if(ps != null) {ps.close();}
if(ct != null) {ct.close();}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}