连接mysql用的JavaBean
来源:互联网 发布:淘宝借贷入口 编辑:程序博客网 时间:2024/05/02 04:23
import java.sql.*;public class MysqlBean { private Connection con = null; private ResultSet rs; private String driverName = "com.mysql.jdbc.Driver"; private String serverName = "localhost"; private String mydatabase = "user"; private String username = "root"; private String password = "138717"; public MysqlBean() { try { String url = "jdbc:mysql://" + serverName + "/" + mydatabase; // a Class.forName(driverName); // con = DriverManager.getConnection(url, username, password); con = DriverManager.getConnection("jdbc:mysql://" + serverName + ":3306/" + mydatabase + "?user=" + username + "&password=" + password + "&useUnicode=true&characterEncoding=UTF-8"); // con.setAutoCommit(false); } catch (ClassNotFoundException e) { // Could not find the database driver System.out.println("Could not find the database driver"); } catch (SQLException e) { // Could not connect to the database System.out.println("Could not connect to the database"); } } public Connection getCon() { return con; } public ResultSet getRs(String sql) throws Exception { try { Statement stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery(sql); } catch (Exception e) { e.printStackTrace(); } return rs; } public int executeUpdate(String sql) { int count = 0; try { Statement stmt = con .createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); count = stmt.executeUpdate(sql); if (count != 0) ; // con.commit(); else ; // con.rollback(); } catch (SQLException ex) { ex.printStackTrace(); } return count; } public void Close() { try { if (con != null) con.close(); } catch (Exception e) { e.printStackTrace(); } }}
1 1
- 连接mysql用的JavaBean
- 连接mysql用的JavaBean
- 用JavaBean连接MySQL
- Jsp,JavaBean,Mysql的连接方法
- Jsp,JavaBean,Mysql的连接方法
- Jsp,JavaBean,Mysql的连接方法
- jsp中连接mysql的javabean
- 连接mysql的javabean实例+简单分页
- jsp中连接mysql的javabean
- 连接mysql的javabean实例+简单分页
- Jsp,JavaBean,Mysql的连接方法
- 连接mysql的javabean实例+简单分页
- 连接mysql的javabean实例+简单分页
- JavaBean连接MySQL
- javaBean连接mysql中的问题
- javaBean连接mysql中的问题
- jsp+javabean 连接 mysql 数据库
- 连接access的javabean
- 自制万能xp镜像让重做系统变得简单
- 转:Mysql常用命令
- python仿真入门-Simulation(1)
- 第四章
- 【C语言】21-struct结构体
- 连接mysql用的JavaBean
- Android 模拟器硬件加速
- LDA模型改进
- Java构造和解析Json数据的两种方法详解
- leetcode-74 Search a 2D Matrix
- String 字符串截取拼装换行 接近Textview换行问题
- java中的多线程
- 递归删除.svn
- android错误 Connection to http://localhost:8080 refused