Conn.java

package com.sql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Conn {// 连接 MySqlfinal String DRIVER = "org.gjt.mm.mysql.Driver";final String URL = "jdbc:mysql://localhost:3306/test";// 连接 ACCESS//final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";//final String URL = "jdbc:odbc:AddressIp";// 连接 SQL Server//final String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";//final String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";// 连接 Oracle//final String DRIVER = "oracle.jdbc.driver.OracleDriver";//final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";final String USER = "root";final String PWD = "root";Connection conn = null;Statement stmt = null;ResultSet rs = null;public Conn() {try {Class.forName(DRIVER);} catch (Exception e) {}}public ResultSet select(String sql) {try {conn = DriverManager.getConnection(URL, USER, PWD);stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);rs = stmt.executeQuery(sql);} catch (Exception e) {}return rs;}public void updata(String sql) {try {conn = DriverManager.getConnection(URL, USER, PWD);stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);stmt.executeUpdate(sql);} catch (Exception e) {}}public void insert(String sql) {try {conn = DriverManager.getConnection(URL, USER, PWD);stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);stmt.executeUpdate(sql);} catch (Exception e) {}}public void close() {try {rs.close();stmt.close();conn.close();} catch (Exception e) {}}public static void main(String[] args) {Conn con = new Conn();String sql = "select * from student";ResultSet rs = con.select(sql);try {while(rs.next()){System.out.println(rs.getString(1) + " " + rs.getString(2));}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}