java程序操作MySQL数据库

　2012-12-08 15:43:06　来源：WEB开发网　闂傚倷绶氬ḿ褍螞閹绢喖绠柨鐕傛嫹

闂傚倷绀侀幉锟犲垂閻㈠灚宕查柟鎵閸庡秵銇勯幒鎴濃偓鐢稿磻閹炬枼妲堟繛鍡楃С濞岊亞绱撻崒姘扁枌闁瑰嚖鎷�

婵犵數濮幏鍐川椤撴繄鎹曢梻渚€娼уú銈吤洪妸鈺佺劦妞ゆ帊鑳堕埊鏇㈡煏閸モ晛浠х紒杈╁仱閺佹捇鏁撻敓锟�闂傚倷绶氬ḿ褍螞閹绢喖绠柨鐕傛嫹　　闂傚倷鑳舵灙缂佺粯顨呴埢宥夊即閵忕姵鐎梺缁樺姇閹碱偆鐥閺屾洘绻濊箛鏇犵獥闂佺厧澹婃禍婊堚€旈崘顏佸亾閿濆骸澧ù鐘欏嫮绠鹃柛顐ゅ枎閻忋儲銇勯弴妯哄姦妞ゃ垺鐟╅幃鈩冩償閵囧府鎷�

核心提示： } public people query_people(String uid) {database_manage db_obj = new database_manage();// String adminid=null;String uid_new, name, banji;uid_new = null;name

}

public people query_people(String uid) {
　database_manage db_obj = new database_manage();
　// String adminid=null;
　String uid_new, name, banji;
　uid_new = null;
　name = null;
　banji = null;
　String sql_query = "select * from people where uid='" + uid + "'";

　try {
　 ResultSet rs = db_obj.query(sql_query);
　 if (rs.next()) {
　　uid_new = rs.getString("uid");
　　name = rs.getString("name");
　　banji = rs.getString("banji");
　 }
　} catch (Exception e) {
　 e.getMessage();
　}
　people new_people = new people(uid_new, name, banji);
　return new_people;
}

public people[] query_people_byscore(int score) {
　database_manage db_obj = new database_manage();
　String uid_new, name, banji;
　uid_new = null;
　name = null;
　banji = null;
　int score_new = 0;

　String sql_query = "select * from people where score=" + score;// sql查询语句

　try {
　 ResultSet rs = db_obj.query(sql_query);// 查询后，返回结果集
　 int num = 0;
　 ResultSet rs_new = rs;
　 while (rs_new.next()) {// 统计结果集中学生个数
　　num++;
　 }
　 // System.out.println(num);

　 people_array1 = new people[num];
　 int i = 0;
　 rs.beforeFirst();// 返回结果集的开始
　 while (rs.next()) {

　　uid_new = rs.getString("uid");
　　name = rs.getString("name");
　　banji = rs.getString("banji");
　　score_new = rs.getInt("score");

　　people_array1[i] = new people(uid_new, name, banji, score_new);
　　i++;
　 }
　} catch (Exception e) {
　 e.getMessage();
　}
　return people_array1;
}

public static void main(String args[]) {

　/*
　 * people new_people=new people();
　 *
　 * manage mr=new manage(); //mr.add_people("000","小明");插入一个学生的信息
　 *
　 * new_people=mr.query_people("001");//查询uid=001的学生信息，返回对象 System.out.
　 * println(""+new_people.getName()+"　 "+new_people.getBanji());
　 * mr.update_people("004", "小王");更新一个学生的信息
　 *
　 * new_people=mr.query_people("004");//更新后查询
　 *
　 * System.out.println(""+new_people.getName()+"　 "+new_people.getBanji(
　 * ));
　 */