connoracle.java

一个很详细的考试管理系统。有源文件。还有毕业论文。大家可以仔细参考。

package db;
import java.sql.*;
import javax.sql.*;

public class ConnOracle
{
    String serverName="192.168.1.168";
    String sDBDriver="oracle.jdbc.driver.OracleDriver";
    String sConnStr="jdbc:oracle:thin:@"+serverName+":1521:ora920";
    Connection connect=null;
    ResultSet rs=null;

    public ConnOracle(){
		try{
//			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
		}catch(java.lang.ClassNotFoundException e){
			System.err.println(e.getMessage());
		}catch(Exception e){
			System.err.println(e.getMessage());
		}
	}

	public Connection getConnection() throws SQLException{
		return  DriverManager.getConnection(sConnStr, "zlol", "zloladmin8988");
	}


    public ResultSet executeQuery(String sql){
		try{
			connect = DriverManager.getConnection(sConnStr, "zlol", "zloladmin8988");
			Statement stmt= connect.createStatement();
			rs = stmt.executeQuery(sql);	
		}catch(SQLException e){
			System.err.println(e.getMessage());
		}
		return rs;
	}

	public int executeUpdate(String sql){
		int result=0;
		try{
			connect = DriverManager.getConnection(sConnStr, "zlol", "zloladmin8988");
			Statement stmt = connect.createStatement();
			rs = stmt.executeQuery(sql);	
		}catch(SQLException e){
			System.err.println(e.getMessage());
		}
		return result;
    }

	public static void main(String args[]){
//		String sql="insert into gotable(record_id, user_name,sex,kechen,score) values( gotable$record_id.nextval,'" + name + "'," + sex + ",'" + kechen + "'," + score + ")"; 
		String sql = "insert into  guesttable (record_id,kname,ksex,keamil,kurl,kcontent,ktype,kemotion) VALUES (deliver$Record_Id.Nextval,'CJT','1','cjt','cjt','cjt','1','cjt')";
		//System.out.println(sql);
		ConnOracle co = new ConnOracle();
		co.executeUpdate(sql); 
		System.out.println("IS ....OK ");
	}
}