operatedb.java

来自「点餐系统 非常好的 jsp mysql 我也是别人那里下载来的」· Java 代码 · 共 69 行

package DAO;
import java.sql.*;

public class OperateDB {
	Connection conn=null;
	Statement smt=null;
	ResultSet rs=null;	
	
	   //连接数据库
	    public void getConnection()
	    {
	      try {
	    	  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    	  //conn=DriverManager.getConnection("jdbc:odbc:Driver={SQL Server};Server=(Local)\\DB2005;DateBase=DB_Food;uid=sa;pwd=sasa");
	    	  conn=DriverManager.getConnection("jdbc:odbc:test");	         
	      } catch (Exception ex) {
	          System.out.println("数据库连接失败"+ex.toString());
	      }
	    }
	    //查询方法
	    public ResultSet GetQuery(String sql) {	    	
	    	try { 	    		
	    		 this.getConnection();
		    	 smt=conn.createStatement();
		    	 rs=smt.executeQuery(sql);
		         
		      } catch (Exception ex) {
		          System.out.println("查询数据失败"+ex.toString());
		      }
		      return rs; 	
	    
	    }
	    //关闭连接	    
	    public void CloseConn()
	    {
	    	try{
	    		this.getConnection();
	    		if(conn.isClosed()==false)
	    		{
	    			rs.close();
		    		conn.close();	    		
	    		}
	    	
	    	}catch(Exception ex){
	    		System.out.println("关闭连接异常！"+ex.toString());   		
	    		
	    	}    	
	    }  
	    
	   //增。删。改
	    public int ReturnLine(String sql)
	    {
	    	int count=0;
	    	try {
	    		this.getConnection();
	    		smt=conn.createStatement();
	    		count=smt.executeUpdate(sql);
		    	  
		      } catch (Exception ex) {
		    	  System.out.println("增。删。改数据库失败！"+ex.toString());
		          
		      }
		      return count;	     
	    	
	    }
	

}