用javabean操作sqlserver2005

/*
 * Created on 2007-11-4
 *
 * author :wym

* place:  nxu.edu.cn
 * email:[e-mail]
 */
package Test;
import java.sql.*;
/**
 * @author Administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class conndb2005 {
 String user="sa";
 String password="123";
 String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
 String sConnStr = "jdbc:sqlserver://localhost:1433;DatabaseName=temp";
 Connection conn = null;
 ResultSet rs = null;
 String param[];
 public void setParam(String[] param)
     {
         this.param=param;
     }

 public conndb2005() {
 try {
 Class.forName(sDBDriver);
 }
 catch(java.lang.ClassNotFoundException e) {
 System.err.println("conndb2005(): " + e.getMessage());
 }
 }

 public ResultSet executeQuery(String sql) {
 rs = null;
 try {
 conn = DriverManager.getConnection(sConnStr,user,password);
 Statement stmt = conn.createStatement();
 rs = stmt.executeQuery(sql);
 }
 catch(SQLException ex) {
 System.err.println("aq.executeQuery: " + ex.getMessage());
 }
 return rs;
 } //select
 
 
 public void insertRecord(String sqlinsert) throws SQLException,java.io.UnsupportedEncodingException
    {
        try
        {
            PreparedStatement insert_stm=conn.prepareStatement(sqlinsert);
            if (param!=null)
            for(int i=0;i<param.length;i++)
                 insert_stm.setString(i+1,param[i]);
            insert_stm.executeUpdate();
            insert_stm.close();
            conn.commit();
        }
        catch(Exception e)
        {
            System.out.println(e);
            conn.rollback();
        }       
    }//insert
 public void updateRecord(String sqlupdate) throws SQLException,java.io.UnsupportedEncodingException
    {
        try
        {
            PreparedStatement update_stm=conn.prepareStatement(sqlupdate);
            if (param!=null)
                for (int i=0;i<param.length;i++)
                       update_stm.setString(i+1,param[i]);
                update_stm.executeUpdate();
                update_stm.close();
                conn.commit();
        }
        catch(Exception e)
        {
            System.out.println(e);
            conn.rollback();
        }
    }//update
 public void deleteRecord(String sqldelete) throws SQLException,java.io.UnsupportedEncodingException
    {
        try
        {
            PreparedStatement delete_stm=conn.prepareStatement(sqldelete);
            if (param!=null)
                for (int i=0;i<param.length;i++)
                   delete_stm.setString(i+1,param[i]);
            delete_stm.executeUpdate();
            delete_stm.close();
            conn.commit();
        }
        catch(Exception e)
        {
            System.out.println(e);
            conn.rollback();
        }
    }     //delete

}