mysqldaobean.java

本例子用的是MyEclipse开发环境

package edu.hbut.bean;


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

public class MySQLDAOBean {
	Connection con;
	PreparedStatement pstmt;
	ResultSet rs;

	public MySQLDAOBean() {
		try {
			Class.forName("org.gjt.mm.mysql.Driver");
			String url = "jdbc:mysql://66.2.5.188:3306/student?useUnicode=true&characterEncoding=gbk";
			con = DriverManager.getConnection(url, "root", "root");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 查询单条记录；
	 */
	public String[] query(String uid) {
		String[] usertbl=new String[3];
		try {
			pstmt = con.prepareStatement("select * from usertbl where uid=?");
			pstmt.setString(1, uid);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				usertbl[0]=rs.getString(1);
				usertbl[1]=rs.getString(2);
				usertbl[2]=rs.getString(3);
			}
			return usertbl;
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}

/*	*//**
	 * 查询多条记录；
	 *//*
	public Collection queryAll() {
		Collection c = new ArrayList();
		try {
			pstmt = con.prepareStatement("select * from scores");
			rs = pstmt.executeQuery();
			while (rs.next()) {
				c.add(rs.getString(1));
				c.add(rs.getString(2));
				c.add(rs.getString(3));
				c.add(rs.getString(4));
			}
			return c;
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}

 * 插入记录;
 
	public boolean insertScores(String name, float math, float english,
			float computer) {
		try {
			pstmt = con.prepareStatement("insert into scores values(?,?,?,?)");
			pstmt.setString(1, name);
			pstmt.setFloat(2, math);
			pstmt.setFloat(3, english);
			pstmt.setFloat(4, computer);
			pstmt.execute();
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}

	}*/

}