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

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(); } }*/ }