votedao.java

来自「简单的投票系统」· Java 代码 · 共 49 行

package Vote;

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

public class VoteDAO {
	public VoteDAO() {
	}

	VoteMysqlDb db = new VoteMysqlDb();

	public List getVoteSelect() {
		String sql = "SELECT name,sum FROM vote1";
		ResultSet rs = db.ExcecuteQuery(sql);
		List select = new ArrayList();
		try {
			while (rs.next()) {
				select
						.add(new VoteBean(rs.getString("name"), rs
								.getInt("sum")));
			}
			return select;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

	public static int VoteUpdate(String name) {
		VoteMysqlDb db = new VoteMysqlDb();
		Integer jieguo = 0;
//		String selectTove = "SELECT sum FROM vote1 WHERE name='" + name + "'";
//		ResultSet rs = db.ExcecuteQuery(selectTove);
//		try {
//			if (rs.next()) {
//				jieguo = rs.getInt("sum");
//				jieguo += 1;
//			}
//		} catch (SQLException e) {
//			e.printStackTrace();
//		}
		String sql = "UPDATE vote1 set sum='" + jieguo + "' where name='"
				+ name + "'";
		System.out.println(sql);
		return db.ExcecuteUpdate(sql);
	}

}