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 { // 连接 MySql final 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 block e.printStackTrace(); } } }