database.java

来自「这是我平是的一个小型基于java的数据库系统」· Java 代码 · 共 44 行

import java.sql.*;
public class DataBase{
	private Connection connection=null;
	private Statement statement;
	public ResultSet resultSet;
	public int num=0;
	public DataBase(){
		try{
		String drive="sun.jdbc.odbc.JdbcOdbcDriver";
		    Class.forName(drive);
		    System.out.println("加载驱动器");
		     connection = DriverManager.getConnection
		      ("jdbc:odbc:Exercise");
		    System.out.println("连接数据库成功");
		       statement = connection.createStatement();
				}
				catch(Exception ex){
					System.out.println("数据库未连接上");
		}
	}
	public void add(String FirstName,String MI,String LastName,String Street,String City,String State,String ZIP,String Telephone,String Email){
			   try{
				   statement=connection.createStatement();
				   String in="insert into T_Exercise25(FirstName,MI,LastName,Street,City,State,ZIP,Telephone,Email)" +
				   "values('"+FirstName+"','"+MI+"','"+LastName+"','"+Street+"','"+City+"','"+State+"','"+ZIP+"','"+Telephone+"','"+Email+"')";
				      num+=statement.executeUpdate(in);
				}
			   catch(Exception ex){
				   ex.printStackTrace();
			   }
   }
    public  void delete() {
       try {
         resultSet.deleteRow();
       }
       catch (Exception ex) {
         ex.printStackTrace();
       }
     }




}