JSP实战型程序连载:通用数据库连接JavaBean
来源:互联网 发布:许嵩 知乎 编辑:程序博客网 时间:2024/06/06 10:58
JSP实战型程序连载:通用数据库连接JavaBean _
作者:冷枫@CSDN
package online;
import java.sql.*;
public class DBConn {
private static String rootpath = "web发布路径";
private String sample = "sample";
private Connection con = null;
private Statement stmt = null;
ResultSet rs = null;
/***************************************************************/
private static final String DRIVE = "sun.jdbc.odbc.JdbcOdbcDriver";
//暂时使用jdbc-odbc连接//"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String USERNAME = "sa";
private static final String PASSWORD = "123aaa";
private static final String HOST = "http:127.0.0.1:8080/renshi";
/*************************************************************/
//暂时使用jdbc-odbc数据源
private static final String CONNECTION_STRING = "jdbc:odbc:renshi";
//"jdbc:microsoft:sqlserver://localhost;1433;";
public static String getRootPath() {
return rootpath;
}
public DBConn() { //加载驱动
try {
Class.forName(DRIVE);
}
catch (ClassNotFoundException e) {
System.err.println("DBConn():" + e.toString());
}
catch (Exception e) {
System.err.println("DBConn():" + e.toString());
}
}
public Connection getConnection() { //得到连接
try {
String strUrl = CONNECTION_STRING;
/***********周五晚改动****************************************/
//+ "DatebaseName=renshi," + USERNAME +"," + PASSWORD;
con = DriverManager.getConnection(strUrl, this.USERNAME, this.PASSWORD);
}
catch (Exception e) {
con = null;
}
return con;
}
public void dropConnection() { //关闭连接
try {
closeStmt();
con.close();
}
catch (Exception ignored) {
}
finally {
con = null;
}
}
public ResultSet executeQuery(String sql) { //执行sql查询
ResultSet rs = null;
try {
con = getConnection();
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println("DBConn.executeQuery():" + ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql) { //执行sql更新语句
int i=0;
stmt = null;
rs = null;
try {
con = getConnection();
stmt = con.createStatement();
i= stmt.executeUpdate(sql);
stmt.close();
con.close();
}
catch (SQLException ex) {
System.err.println("DBConn:executeUpdate(0:" + ex.getMessage());
}
return i;
}
public void execute(String sql) { //执行sql语句
stmt = null;
rs = null;
try {
con = getConnection();
stmt = con.createStatement();
stmt.execute(sql);
stmt.close();
con.close();
}
catch (SQLException ex) {
System.err.println("DBConn:excute():" + ex.getMessage());
}
}
public void closeConn() { //关闭sql连接
try {
stmt.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
public void closeStmt() { //关闭sql连接
try {
con.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
/**
* main
*/
public static void main(String[] args) throws SQLException {
DBConn one=new DBConn();
ResultSet rs=one.executeQuery("select * from PS_INFO");
while(rs.next()){
System.out.println(rs.getString(2));
}
}
}
import java.sql.*;
public class DBConn {
private static String rootpath = "web发布路径";
private String sample = "sample";
private Connection con = null;
private Statement stmt = null;
ResultSet rs = null;
/***************************************************************/
private static final String DRIVE = "sun.jdbc.odbc.JdbcOdbcDriver";
//暂时使用jdbc-odbc连接//"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String USERNAME = "sa";
private static final String PASSWORD = "123aaa";
private static final String HOST = "http:127.0.0.1:8080/renshi";
/*************************************************************/
//暂时使用jdbc-odbc数据源
private static final String CONNECTION_STRING = "jdbc:odbc:renshi";
//"jdbc:microsoft:sqlserver://localhost;1433;";
public static String getRootPath() {
return rootpath;
}
public DBConn() { //加载驱动
try {
Class.forName(DRIVE);
}
catch (ClassNotFoundException e) {
System.err.println("DBConn():" + e.toString());
}
catch (Exception e) {
System.err.println("DBConn():" + e.toString());
}
}
public Connection getConnection() { //得到连接
try {
String strUrl = CONNECTION_STRING;
/***********周五晚改动****************************************/
//+ "DatebaseName=renshi," + USERNAME +"," + PASSWORD;
con = DriverManager.getConnection(strUrl, this.USERNAME, this.PASSWORD);
}
catch (Exception e) {
con = null;
}
return con;
}
public void dropConnection() { //关闭连接
try {
closeStmt();
con.close();
}
catch (Exception ignored) {
}
finally {
con = null;
}
}
public ResultSet executeQuery(String sql) { //执行sql查询
ResultSet rs = null;
try {
con = getConnection();
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println("DBConn.executeQuery():" + ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql) { //执行sql更新语句
int i=0;
stmt = null;
rs = null;
try {
con = getConnection();
stmt = con.createStatement();
i= stmt.executeUpdate(sql);
stmt.close();
con.close();
}
catch (SQLException ex) {
System.err.println("DBConn:executeUpdate(0:" + ex.getMessage());
}
return i;
}
public void execute(String sql) { //执行sql语句
stmt = null;
rs = null;
try {
con = getConnection();
stmt = con.createStatement();
stmt.execute(sql);
stmt.close();
con.close();
}
catch (SQLException ex) {
System.err.println("DBConn:excute():" + ex.getMessage());
}
}
public void closeConn() { //关闭sql连接
try {
stmt.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
public void closeStmt() { //关闭sql连接
try {
con.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
/**
* main
*/
public static void main(String[] args) throws SQLException {
DBConn one=new DBConn();
ResultSet rs=one.executeQuery("select * from PS_INFO");
while(rs.next()){
System.out.println(rs.getString(2));
}
}
}
- JSP实战型程序连载:通用数据库连接JavaBean
- JSP实战型程序连载:通用数据库连接JavaBean
- JSP实战型程序连载
- jsp+javabean+mysql数据库连接
- jsp(数据库连接初步和javabean)
- jsp:jdbc 数据库连接程序
- 如何tomcat下配置jsp、servlet.JavaBean.数据库连接池.虚拟目录
- tomcat下配置jsp、servlet.JavaBean.数据库连接池.虚拟目录
- Servlet+JSP+JavaBean+C3P0数据库连接池---本科生教务管理系统
- Mysql通用查询操作类(Jsp+servlet+javaBean+Mysql)
- 第一个JSP+JavaBean+Tomcat的程序
- JSP+Servlet+JavaBean+JDBC示例程序
- 通用数据库连接。
- jsp+javabean
- JSP JavaBean
- jsp---->JavaBean
- jsp+javabean
- JSP JavaBean
- 表格内容为空时怎样显示其边框
- 对《原子对象模式》一文的补充
- 新年快乐
- ib和dll文件的区别和联系
- SQL 指定数据源的复习
- JSP实战型程序连载:通用数据库连接JavaBean
- #pragma详解
- 新立得代理设置问题
- open-JWeb(RAD)快速开发平台介绍
- 博客开博
- Physio Bank
- 取得鼠标位置
- GOOGLE 地图推出 谷歌春运交通图 ,很强很实用
- Thunk技术应用