db.java

现代社会离不开手机和电话

import java.sql.*;

public class DB
{

    public DB(){}

    public void ConnectionToServer()
    {
        CloseToServer();
        
        try { 
        	//数据库连接语句        	
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=./telDB", "", "");
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}     
    }

    public void CloseToServer()
    {
        if(conn != null)
            conn = null;
    }

    public void AddInfo(String s)
    {
        ConnectionToServer();
        try {
			st = conn.createStatement();
			st.executeUpdate(s);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
        CloseToServer();
    }

    public boolean DelInfo(String s)
    {
        ConnectionToServer();
        try {
			st = conn.createStatement();
			st.executeUpdate(s);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
        CloseToServer();
        return true;
    }

    public ResultSet SelectInfo(String s)
    {
        ResultSet resultset = null;
        ConnectionToServer();
        try {
			st = conn.createStatement();
			resultset = st.executeQuery(s);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
        CloseToServer();
        return resultset;
    }

    public void UpdInfo(String s)
    {
        ConnectionToServer();
        try {
			st = conn.createStatement();
			st.executeUpdate(s);
			CloseToServer();
			} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();			
		}       
    }

    Connection conn;
    Statement st;
}