package com;
import java.sql.*;
public class DBBean {
private String driverStr="oracle.jdbc.driver.OracleDriver";
private String connStr;
private Connection conn;
private Statement stmt;
public Connection getConn() {
return conn;
}
public void setConn(Connection conn) {
this.conn = conn;
}
public String getConnStr() {
return connStr;
}
public void setConnStr(String connStr) {
this.connStr = connStr;
}
public String getDriverStr() {
return driverStr;
}
public void setDriverStr(String driverStr) {
this.driverStr = driverStr;
}
public Statement getStmt() {
return stmt;
}
public void setStmt(Statement stmt) {
this.stmt = stmt;
}
public DBBean(){
try{
Class.forName(driverStr);
}
catch(ClassNotFoundException ex){
System.out.println(ex.getMessage());
}
}
public ResultSet executeQuery(String sql){
ResultSet rs=null;
try{
conn=DriverManager.getConnection(connStr,"system","root");
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.out.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql){
int result=0;
try{
conn=DriverManager.getConnection(connStr,"system","root");
stmt=conn.createStatement();
result=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.out.println(ex.getMessage());
}
return result;
}
public void close(){
try{
stmt.close();
conn.close();
}
catch(SQLException ex){
System.out.println(ex.getMessage());
}
}
}
vote.rar （18个子文件） 
vote 
.project 1KB .settings com.genuitec.eclipse.j2eedt.core.prefs 1KB .mymetadata 286B WebRoot login.jsp 1KB manage.jsp 1KB WEB-INF web.xml 277B lib classes com DBBean.class 3KB vote.jsp 542B index.jsp 1KB META-INF MANIFEST.MF 39B
000.jpg 39KB add.jsp 391B process.jsp 723B info.jsp 1KB check.jsp 87B delete.jsp 301B .myeclipse src com DBBean.java 2KB .classpath 433B资源评论
ryb_cool
- 粉丝: 8
- 资源: 2
