db.java~4~

来自「班级管理系统」· JAVA~4~ 代码 · 共 58 行

package myproject;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.ResultSet;
public class DB {
    private Connection con;
    private Statement st;
    private ResultSet rs;
    public DB() {
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost;DatabaseName=mianmu;","sa","");
            st=con.createStatement();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
            /** @todo Handle this exception */
        }
    }
    public ResultSet Select(String str)
   {
       try {
           rs = st.executeQuery(str);
       } catch (SQLException ex) {
       }
       return rs;
   }
   public int Update(String str)
   {
       int x=0;
       try {
           x = st.executeUpdate(str);
       } catch (SQLException ex) {
       }
       return x;
   }
   public void Close()
   {
       if(rs!=null)
           try {
               rs.close();
           } catch (SQLException ex) {
           }
       if(st!=null)
           try {
               st.close();
           } catch (SQLException ex1) {
           }
       if(con!=null)
           try {
               con.close();
           } catch (SQLException ex2) {
           }
   }

}