db.java

电话簿管理系统

package Bean;

import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DB {

	private Connection conn;
	private Statement stmt;
	private ResultSet rs;
	private Vector vectorAllInfo = new Vector();
	
	public void getConnection(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection("jdbc:odbc:oradsn","sa","12345");
			stmt = conn.createStatement();
		}
		catch(Exception e){
			stmt = null;
			conn = null;
			System.out.println(e.getMessage());
		}
	}
	
	public Vector getVectorAllInfo(){		
		try{
			this.getConnection();
			rs = stmt.executeQuery("select * from myaddrbook");
			while(rs.next()){
				Vector row = new Vector();
				String id = rs.getString("id");
				String firstname = rs.getString("firstname");
				String lastname = rs.getString("lastname");
				String jobtitle = rs.getString("jobtitle");
				String department = rs.getString("department");
				String offph = rs.getString("offph");
				String mobile = rs.getString("mobile");
				String email = rs.getString("email");
				
				row.add(id);
				row.add(firstname);
				row.add(lastname);
				row.add(jobtitle);
				row.add(department);
				row.add(offph);
				row.add(mobile);
				row.add(email);
				vectorAllInfo.add(row);
			}
		}
		catch(Exception e){
			System.out.println("dbbean错误: "+e.getMessage());
			vectorAllInfo = null;
		}
		this.closeConnection();
		return vectorAllInfo;
	}
	
	public boolean addContact(String sql){
		boolean finish = false;
		try{
			this.getConnection();
			stmt.execute(sql);
			finish = true;
		}
		catch(Exception e){
			System.out.println(e.getMessage());
			finish = false;
		}
		return finish;
	}
	
	public boolean modifyContact(String sql){
		boolean finish = false;
		try{
			this.getConnection();
			stmt.execute(sql);
			finish = true;
		}
		catch(Exception e){
			System.out.println(e.getMessage());
			finish = false;
		}
		return finish;
	}
	
	public boolean delContact(String sql){
		boolean finish = false;
		try{
			this.getConnection();
			stmt.execute(sql);
			finish = true;
		}
		catch(Exception e){
			System.out.println(e.getMessage());
			finish = false;
		}
		return finish;
	}
	
	public Vector displayContactByID(String ID){
		Vector contact = new Vector();
		try{
			String sql = "select * from myaddrbook where ID = '" + ID + "'";
			this.getConnection();
			rs = stmt.executeQuery(sql);
			while(rs.next()){
				contact.add(rs.getString("firstname"));
				contact.add(rs.getString("lastname"));
				contact.add(rs.getString("jobtitle"));
				contact.add(rs.getString("department"));
				contact.add(rs.getString("offph"));
				contact.add(rs.getString("mobile"));
				contact.add(rs.getString("email"));
			}
		}
		catch(Exception e){
			contact = null;
			System.out.println(e.getMessage());
		}
		return contact;
	}
	
	public void closeConnection(){
		try{
			if(conn!=null){
				conn.close();
			}
		}
		catch(Exception e){
			System.out.println(e.getMessage());
		}
	}
	
}