package yhgl;
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();
}
}
}
用户管理系统
需积分: 9 39 浏览量
2008-05-31
07:29:51
上传
评论
收藏 14KB RAR 举报
JSP用户管理系统-示例程序代码.rar （15个子文件） 
用户管理-第八章示例程序 
login.jsp 1KB update_deal.jsp 1KB WEB-INF web.xml 410B lib 
catalina-root.jar 5KB classes yhgl connectDB.class 2KB connectDB.java 1KB index.jsp 692B add.jsp 1KB list.jsp 2KB error.jsp 914B update.jsp 2KB 数据库 yhgl_table.sql 801B index_add.jsp 766B quit.jsp 305B delete.jsp 520B
评论0