conn2.java

来自「基于JAVAJSP的网上书店系统需要的下载 希望对大家有用」· Java 代码 · 共 94 行

package ckstudio.db;
import java.sql.*;
public class conn2 {
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";//数据库地址:端口:SID
String user="scott";//用户名
String pass="oracledb";//密码
Connection conn = null;
ResultSet rs = null;
public conn2() {
try {
Class.forName(sDBDriver); 
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("conn(): " + e.getMessage());
}
}
public void executeInsert(String sql)
	{
	try
		{
		conn=DriverManager.getConnection(sConnStr,user,pass);
		Statement stmt=conn.createStatement();

		int n=stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
			System.err.println("conn.executeUpdate:"+ ex.getMessage());
		}
	}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr,user,pass); 
Statement stmt;
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
    ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
} 
catch(SQLException ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeDelete(String sql)
	{
	try
		{
		conn=DriverManager.getConnection(sConnStr,user,pass);
		Statement stmt=conn.createStatement();
		stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
			System.err.println("conn.executeDelete: "+ ex.getMessage());
		}
	}
public int executeUpdate(String sql)
	{
	    int n=0;
	try
		{
		conn=DriverManager.getConnection(sConnStr,user,pass);
		Statement stmt=conn.createStatement();
		
		n=stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
			System.err.println("conn.executeDelete: "+ ex.getMessage());
		}
		return n;
	}
public void Close()
   {
    try{
       if(rs!=null)
       {
          rs.close();
       }
       if(conn!=null)
       {
          conn.close();
        }
       } 
       catch(SQLException ex)
		{
			System.err.println("conn.executeDelete: "+ ex.getMessage());
		}

   }
}