jdbconnection.java

来自「实现从用户登陆页面到用户信息页面的跳转。完成数据库连接」· Java 代码 · 共 96 行

package cn.com.yunda.util;

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

/**
 *
 *@author baiwei
 *@version 2008-11-6 下午04:35:19
 */
public class JDBConnection {
	
	java.sql.Connection conn=null;
	Statement stmt=null;
	
	
	
	public JDBConnection(){
		  try
		  {
		  Class.forName("oracle.jdbc.driver.OracleDriver");
		  conn =DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:icss","YNUSEI","baiwei");
		  stmt=conn.createStatement();
		  }
		  catch (Exception e){
		  System.out.println("Error"+"---"+e.getMessage());
         }
	
	}
	public ResultSet query(String sql){
		ResultSet rs=null;
		try{
			rs=stmt.executeQuery(sql);
		}
		catch(Exception e){
			System.out.println("Error"+"-----"+e.getMessage());
			
		}
	    return rs;
	}
	
	public void delete(String sql){
		
		try{		
			int changeNum=stmt.executeUpdate(sql);
			System.out.println("删除了"+changeNum+"行");
		}
		catch(Exception e){
			
			System.out.println("Error"+"----"+e.getMessage());
		}	
	}
	public void update(String sql){
		
		try{
			int changeNum=stmt.executeUpdate(sql);
			System.out.println("更新了"+changeNum+"行");
			
			
		}
		catch(Exception e){
			System.out.println("Error"+"-----"+e.getMessage());
		}
	}	
	
	public void insert(String sql){
	
	try{
		int changeNum=stmt.executeUpdate(sql);
		System.out.println("插入了"+changeNum+"行");

	}
	catch(Exception e){
		System.out.println("Error"+"-----"+e.getMessage());
	}
		
	}
	
   public void close(){
   try{
	   
	   conn.close();
	   
   }
   catch(Exception e)
   {
	   System.out.println("Error"+"------"+e.getMessage());
   }
   }
}