我这个试过可以。
package firm;
import java.sql.*;public class connDB{
String drv="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@192.168.0.2:1521:shopdb";
public Connection conn=null;
public Statement stmt=null;
ResultSet rs=null;
//load driver
public connDB()
{
try{
Class.forName(drv);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("connDB():"+e.getMessage());
}
}
//create a connection and query.
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(url,"weber","weber");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
} catch (SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
//datebase operatate
public void executeUpdate(String sql) throws SQLException
{
//stmt=null;
//rs=null;
try{
conn=DriverManager.getConnection(url,"aaaa","webc");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeQuery(sql);
stmt.close();
conn.close();
} catch(SQLException ex){
System.err.println("sq.executeQuery:"+ex.getMessage());
throw ex;
}
}
//release resources..
public void closeStmt(){
try{
stmt.close();
} catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
} catch(SQLException e){
e.printStackTrace();
}
}
}
package firm;
import java.sql.*;public class connDB{
String drv="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@192.168.0.2:1521:shopdb";
public Connection conn=null;
public Statement stmt=null;
ResultSet rs=null;
//load driver
public connDB()
{
try{
Class.forName(drv);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("connDB():"+e.getMessage());
}
}
//create a connection and query.
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(url,"weber","weber");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
} catch (SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
//datebase operatate
public void executeUpdate(String sql) throws SQLException
{
//stmt=null;
//rs=null;
try{
conn=DriverManager.getConnection(url,"aaaa","webc");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeQuery(sql);
stmt.close();
conn.close();
} catch(SQLException ex){
System.err.println("sq.executeQuery:"+ex.getMessage());
throw ex;
}
}
//release resources..
public void closeStmt(){
try{
stmt.close();
} catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
} catch(SQLException e){
e.printStackTrace();
}
}
}
解决方案 »
- 问题我也说不清楚,有tomcat错误,也有java类型转换错误帮忙看看
- 公司邮箱显示空白
- 保存.js文件時提示使用"ISO-8895-1"字符編碼出錯﹐無法映射某些字符
- 在Jbuilder里面需要配置TOMCAT 吗!又怎么样调整测试JSP!新手疑难
- 当地址栏URL=www.abc.com/3366 页面跳转
- 如何在后台定时查询指定文件夹里面是否有*.wav文件,如果有则直接保存到数据库中?
- 不知道怎么以运行程序就自动进入了DEBUG状态了
- 据说是当今最好的学Servlet&JSP的书,大家进来看是不是?顶也送分
- 如何用bean将字符串等直接显示到浏览器端?
- 在java或jsp中,如何将web页上表格中的数据导入到excel中?多谢了,一定给分,希望直接给程序,不要写连接,因为我现在上望不方便
- JSP实现画图表???
- jsp+tomcat4.1+windows 2000 Server
import base.log.*;import java.sql.*;public class DataBaseAccess { private BsLog iLog = null;
private Connection Conn;
private Statement Stmt; public DataBaseAccess()
throws Exception {
String strDBDriver = "XXXX";
String strDBURL = "XXXX";
String strDBSid = "XXXX";
String strUID = "XXXX";
String strPassword = "XXXX"; Class.forName(strDBDriver);
Conn = DriverManager.getConnection(strDBURL+strDBSid,strUID,strPassword);
Conn.setAutoCommit(false);
Stmt = Conn.createStatement();
} public int executeUpdate(String sql)
throws SQLException {
int status = Stmt.executeUpdate(sql); return status;
} public PreparedStatement prepareStatement(String sql)
throws SQLException {
return Conn.prepareStatement(sql);
} public void commit()
throws SQLException {
Conn.commit();
} public void rollback()
throws SQLException {
Conn.rollback();
} public void releaseconnection()
throws SQLException {
Stmt.close();
Conn.close();
}
}
import java.sql.*;public class databaseConnect
{
private String user;
private String password;
private String nurl;
private String driverAddr;
private boolean flag=false;
private Connection con;
public void setUser(String user)
{
this.user=user;
}
public void setPassword(String password)
{
this.password=password;
}
public void setNurl(String nurl)
{
this.nurl=nurl;
}
public boolean getThisflag()
{
return this.flag;
}
public Connection getConnection()
{
String nurl="";
String user="";
String password="";
String driverAddr="";
try
{
driverAddr="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driverAddr).newInstance();
nurl=this.nurl;
user=this.user;
password=this.password;
this.con=DriverManager.getConnection(nurl,user,password);
this.flag=true;
System.out.println("连接成功!");
}
catch(Exception e)
{
System.out.println("连接失败!");
}
finally
{
return this.con;
}
}
public void conClose()throws Exception
{
this.con.close();
}
}