dataset2.java

一个个人信息管理系统

package soft1Method;
import java.sql.*;
import javax.swing.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Dataset2 {
    public Dataset2() {
    }

        String url="jdbc:odbc:PersonalDB";
        String username="";
        String password="";
    public Connection Getcon() throws ClassNotFoundException, SQLException {
        try{
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          Connection con=DriverManager.getConnection(url,username,password);
          return con;
     }
     catch(Exception a){
    JOptionPane.showMessageDialog(null,a.getMessage(),"数据库没连上？",JOptionPane.ERROR_MESSAGE);
 }
 return null;
   }
      public ResultSet Rs(String s ) throws SQLException,
     ClassNotFoundException {

     Statement stmt2=Getcon().createStatement();
     ResultSet rs2 = stmt2.executeQuery(s);
     return rs2;
      }

        public void Update(String s) {
           try{
            Statement stmt2=Getcon().createStatement();
            stmt2.executeUpdate(s);}
        catch(Exception e){
            e.printStackTrace();

        }

        }

}