databasebean.java

包含了很多JAVA的例子,适合初学者用来参考一下,谢谢支持.

package Beijing2008;

import java.sql.*;
import java.text.*;
import java.util.*;

public class DatabaseBean {

	private String name = new String("");
	private String sex;
	private String regTelephone;
	private String email;
	private String intro;
	private DatabaseBean[] rows;

	public String getName(){
		return this.name;
	}
	public void setName(String name){
		this.name = name;
	}
	public String getSex(){
		return this.sex;
	}
	public void setSex(String sex){
		this.sex = sex;
	}
	public String getRegTelephone(){
		return this.regTelephone;
	}
	public void setRegTelephone(String regTelephone){
		this.regTelephone = regTelephone;
	}
	public String getEmail(){
		return this.email;
	}
	public void setEmail(String email){
		this.email = email;
	}
	public String getIntro(){
		return this.intro;
	}
	public void setIntro(String intro){
		this.intro = intro;
	}
	
	private Connection getConnection()
	{
		Connection con=null;
	        try{
			Class.forName("com.mysql.jdbc.Driver").newInstance();		
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/helloBeijing?user=chen&password=admin&useUnicode=true&characterEncoding=GB2312");		
		}
		catch(Exception e){
		        e.printStackTrace(System.err);
		}
		return con;
	}

	public DatabaseBean[] getRows(){
		ResultSet rs=query("SELECT * FROM volunteers");
		ArrayList res = new ArrayList();
		try{
		for(; rs.next(); ){
			DatabaseBean b=new DatabaseBean();
			b.name = rs.getString("name");
			b.sex = rs.getString("sex");
			b.email = rs.getString("email");
			b.regTelephone = rs.getString("regTelephone");
			b.intro = rs.getString("intro");
			res.add(b);
			}
		}catch(Exception e){}
		
		DatabaseBean res2[] = new DatabaseBean[res.size()];
		for (int i=0;i<res2.length;i++)
		 res2[i]=new DatabaseBean();
		res2 = (DatabaseBean[])res.toArray(res2);
		return res2;

	}
	public ResultSet query(String sql) {
		ResultSet rs =null;	
		try {
			Connection conn = getConnection(); 
			Statement stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	
	public void insert() {
        	try {
	            StringBuffer q = new StringBuffer(200);
	            q.append("INSERT INTO volunteers(name,sex,regTelephone,email,intro) VALUES (");
	            q.append("'" + name + "','");
	            q.append(sex + "','");
	            q.append(regTelephone + "','");
	            q.append(email+ "','");
	            q.append(intro+ "')");
	            update(q.toString());
	        } catch (Exception e) {
	        	System.err.println(e.getMessage());
	        }
	    }

	public int update(String sql) {
		int result = 0;
		try {
			Connection conn = getConnection(); 
			Statement stmt = conn.createStatement();
			result = stmt.executeUpdate(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return result;
	}



}