conn.java

主要是描述的同学录系统

package com.user;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Conn {
	public static Connection con;

	static Statement stmt = null;

	static ResultSet rs = null;

	public Connection getConn() {
		String CLASSFORNAME = "oracle.jdbc.driver.OracleDriver";
		String SERVANDDB = "jdbc:oracle:thin:@localhost:1521:ora";
		String USER = "cheng";
		String PWD = "cheng";
		try {
			Class.forName(CLASSFORNAME);
			con = DriverManager.getConnection(SERVANDDB, USER, PWD);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;
	}

	public static void closeConn() {
		try {
			con.close();
		} catch (Exception e) {
			System.out.print("关闭出现错误");
		}
	}
}