conn.java

一般性的内容,可以生成和修改还在有其他的好友添加等等

package bbs;
import java.sql.*;
public class Conn {
     Connection con=null;
     Statement stmt=null;
     ResultSet rs=null;
     public Conn(){
    	 try{
    		 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); 
    		 String url="jdbc:sqlserver://localhost:1433;DatabaseName=db";
    		 String user="sa";
    		 String pwd="zdsoft6284!#)@";
    		 con=DriverManager.getConnection(url,user,pwd);
    		 stmt=con.createStatement();
    	 }catch(Exception e){}
     }
     public ResultSet eQ(String sql){
    	 try{
    		 rs=stmt.executeQuery(sql);
    	 }catch(Exception e){}
    	 return rs;
     }
     public int eU(String sql){
    	 int r=0;
    	 try{
    		 stmt=con.createStatement();
    		 r=stmt.executeUpdate(sql);
    		 return 1;
    	 }catch(Exception e){}
    	 return -1;
     }
     public void close(){
    	 try{
    		 stmt.close();
    		 stmt=null;
    	 }catch(Exception e){}
    	 try{
    		 con.close();
    		 con=null;
    	 }catch(Exception e){}
     }
}