package wstp;
import java.sql.*;
public class connectDB
{
String DBDriver = "oracle.jdbc.driver.OracleDriver";
String DBUrl = "jdbc:oracle:thin:@localhost:1521:ORACLE";
String DBUser = "jerry";
String DBPsw = "123456";
Connection conn = null;
PreparedStatement stmt = null;
public connectDB()
{
try
{
Class.forName(DBDriver);
conn = DriverManager.getConnection(DBUrl,DBUser,DBPsw);
}
catch (Exception e)
{
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql) throws Exception
{
try
{
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
return this.stmt.executeQuery();
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
}
public int executeUpdate(String sql) throws Exception
{
try
{
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
return this.stmt.executeUpdate();
}
catch (Exception e)
{
e.printStackTrace();
return 0;
}
}
public void closeDB()
{
try
{
conn.close();
stmt.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
网上投票示例程序（jsp+oracle）
需积分: 9 54 浏览量
2009-02-02
10:36:59
上传
评论
收藏 9KB RAR 举报
.rar （13个子文件） 
网上投票示例程序 
update_deal.jsp 2KB WEB-INF web.xml 410B classes wstp connectDB.class 2KB connectDB.java 1KB index.jsp 1KB admin.jsp 1KB tp.jsp 2KB error.jsp 88B update.jsp 2KB deal.jsp 2KB 数据库 wstp_table.sql 1KB index_add.jsp 942B delete.jsp 623B资源评论
