func.java

本系统是投票系统

package com;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import com.Dbase;

public class Func {
	Dbase db;
	Vo vo;

	Connection con = null;

	PreparedStatement pstmt = null;

	ResultSet rs = null;

	Statement stmt;
	List list=null;

	boolean flag = false;

	int num = 0;
	 public List getAll()
	 {
		 list = new ArrayList();
		 String sql="select * from toupiao ";
		 try
	    	{
	    		
	    		con=db.getConnection();
	    		stmt=con.createStatement();
	    		rs=stmt.executeQuery(sql);
	    		while(rs.next())
	    		{
	    		 Vo	vo = new Vo();
	    		 vo.setId(rs.getInt(1));
	    		 vo.setName(rs.getString(2));
	    		 vo.setMark(rs.getInt(3));
	    		 list.add(vo);
	    		}
	    		rs.close();	
	    		stmt.close();
	    		con.close();
	    	}catch(Exception e)
	    	{
	    		System.out.println("查询出现异常");
	    		e.printStackTrace();
	    	}
		 
		 return list;
		 
	 }

	public boolean a(String id) {
		String str = "select * from toupiao where id=" + id;

		try {

			con = db.getConnection();
			System.out.println("bbbb");
			stmt = con.createStatement();
			rs = stmt.executeQuery(str);

			if (rs.next()) {
				num = rs.getInt(3);
				System.out.println("aaaa");
				String sql = "update toupiao set mark=" + (num + 1)
						+ "where id=" + id;
				System.out.println(sql);
				stmt.executeUpdate(sql);
				flag = true;
			}
			rs.close();
			stmt.close();
			con.close();

		} catch (Exception e) {
			System.out.println("失败!!");
			e.printStackTrace();
		}
		return flag;
	}

	public boolean set(String ip) {
		try {
			String str = "select max(id) from friend";
			String sql = "insert into ip values(?,?)";
			con = db.getConnection();
			System.out.println("bbbb");
			stmt = con.createStatement();
			rs = stmt.executeQuery(str);
			if (rs.next()) {
				System.out.println("插入IP成功");
				flag = true;
			}
			rs.close();
			stmt.close();
			pstmt = con.prepareStatement(sql);
			pstmt.setInt(1, num + 1);
			pstmt.setString(2, ip);
			pstmt.executeUpdate();
			con.close();
		} catch (Exception e) {
			System.out.println("插入IP成功失败!!");
			e.printStackTrace();
		}
		return flag;
	}

	public boolean find(String ip) {
		try {
			String sql = "select * from ip where ip='"+ip+"'";
			con = db.getConnection();
			System.out.println("bbbb");
			stmt = con.createStatement();
			rs = stmt.executeQuery(sql);
			if (rs.next()) {
				System.out.println("已投票");
				flag = true;
			}
			rs.close();
			stmt.close();
			con.close();
		} catch (Exception e) {
			System.out.println("失败!!");
			e.printStackTrace();
		}
		return flag;
	}

	public Vo getVo() {
		return vo;
	}

	public void setVo(Vo vo) {
		this.vo = vo;
	}

}