自己做的网上投票系统源代码

      package com.bean;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBBean {
      private Connection cn;
      private Statement stmt;
      private ResultSet rs=null;
      public boolean open(){
          String url="jdbc:mysql://localhost:3306/vote";
          String uname="root";
          String upwd="123456";
    	  try {
		Class.forName("com.mysql.jdbc.Driver");
		cn=DriverManager.getConnection(url,uname,upwd);
		stmt=cn.createStatement();
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
    	  return true;  	  
      }
      public ResultSet executeQuery(String sql){
    	  open();
    	  try {
			rs=stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	  return rs;
      }
      public boolean executeUpdate(String sql){
    	  open();
    	  int result=0;
    	  try {
			result=stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	  return true;
      }
      public void close(){
    	  try {
			stmt.close();
			cn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	  
    	  
      }
     /* public static void main(String args[]){
    	 DBBean b= new DBBean();
    	 b.open();
    	// b.executeUpdate("insert into vote values(3,'song','3')");
    	 ResultSet r=b.executeQuery("select * from vote");
    	 try {while(r.next())
			System.out.println(r.getString("id")+" "+r.getString("item")+" "+r.getString("count"));
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
      }*/
}