db.java

没有什么难的

package DB;
import java.sql.*;
import java.io.*;
import java.util.*;

public class DB{
	Properties pro = new Properties();
	FileInputStream read;
	Connection conn;
	Statement stmt;
	ResultSet rs;
	String dbURL = "jdbc:mysql://localhost:3306/temp";
	//String dbURL = "jdbc:odbc:email";
	String dbName = "root";
	String dbPwd = "congyang";
	String classForName = "com.mysql.jdbc.Driver";

	public DB()
	{
		
		try
		{
			read = new FileInputStream("dbSetting.ini");
			pro.load(read);
			dbURL = pro.getProperty("dbURL");
			dbName = pro.getProperty("dbName");
			dbPwd = pro.getProperty("dbPwd");
			classForName = pro.getProperty("classforname");
		}
		catch (IOException e)
		{
			e.printStackTrace();
		}
		
		this.open();
	}

	public void open(){
		try{
			Class.forName(classForName).newInstance();
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection(dbURL, dbName, dbPwd);
			stmt = conn.createStatement();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public ResultSet search(String sql){
		try{
			rs = stmt.executeQuery(sql);			
		}catch(Exception e2){
			e2.printStackTrace();
		}
		return rs;
	}
	
	public void update(String sql){
		try{
			stmt.executeUpdate(sql);
		}catch(Exception e3){
			e3.printStackTrace();
		}
	}
	
	public void close(){
		try{
			stmt.close();
			conn.close();
		}catch(Exception ee){
			ee.printStackTrace();
		}
		
	}


	public static void main(String[] args){
		String s = null;
		ResultSet rs;
		DB db = new DB();
		
		String sql1 = "select deptName from department;";
		rs = db.search(sql1);
		//String [] sResult = null;
		Vector v = new Vector();

		//int count = 0;
		try
		{
			while(rs.next())
			{
				//String sDeptName = new String((rs.getString("deptName")).getBytes("ISO8859_1"),"GBK");
				String sDeptName = new String((rs.getString("deptName")).getBytes("ISO8859_1"),"GBK");

				v.add(sDeptName);
				
				System.out.println(sDeptName);

			}
		}
		catch (Exception e)
		{
		}
		db.close();
	}

}
/*显示中文
String x=new String((rs.getString("title")).getBytes("ISO8859_1"),"GBK");  */