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();
		}
	}
	
}