JSP做的nba投票系统，比较简单

package com; import java.util.*; import java.sql.*; import java.text.*; public class words extends Conn { //定义成员变量 private int WordsID; private String WordsContent; private String WordsTime; private String UserName; private String sql; private SimpleDateFormat timeFormatter; //构造函数，初始化成员变量 public words() { WordsID=0; WordsContent=""; UserName=""; timeFormatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); WordsTime=timeFormatter.format(new java.util.Date()); sql=""; } public boolean add_words() { sql="insert into words "; sql=sql + "("; sql=sql + "WordsContent,"; sql=sql + "WordsTime,"; sql=sql + "UserName"; sql=sql + ") "; sql=sql + "values("; sql=sql + "'" + WordsContent + "',"; sql=sql + "'" + WordsTime + "',"; sql=sql + "'" + UserName + "'"; sql=sql + ")"; boolean isAdd = super.exeSql(sql); return isAdd; } public boolean init() { sql="select * from words where WordsID="; sql=sql + WordsID; try { ResultSet rs = super.executeQuery(sql); if (rs.next()) { //获取留言内容 this.WordsID=rs.getInt("WordsID"); this.WordsContent=rs.getString("WordsContent"); this.WordsTime=rs.getString("WordsTime"); this.UserName=rs.getString("UserName"); return true; } else { return false; } } catch(Exception ex) { System.out.println(ex.toString()); return false; } } public ResultSet show_words() { sql="select * from words"; ResultSet rs = null; try { rs = super.executeQuery(sql); } catch(Exception ex) { System.out.println(ex.toString()); } return rs; } public void setWordsID(int WordsID) { this.WordsID = WordsID; } public int getWordsID() { return this.WordsID; } public void setWordsContent(String WordsContent) { this.WordsContent = WordsContent; } public String getWordsContent() { return this.WordsContent; } public void setWordsTime(String WordsTime) { this.WordsTime = WordsTime; } public String getWordsTime() { return this.WordsTime; } public void setUserName(String UserName) { this.UserName = UserName; } public String getUserName() { return this.UserName; } }