- 论坛徽章:
- 0
|
MySQL数据库基本操作 java- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class DbManager {
- private Connection connection = null;//数据库连接对象
- private Statement statement = null;//数据库操作对象
- private ResultSet resultSet = null;//查询后返回的结果集对象
- private static final String DRIVER = "com.mysql.jdbc.Driver";//数据库驱动路径
- private static final String URL = "jdbc:mysql://localhost:3306/此处为数据库名称";//数据库实体路径
- private static final String USER = "root";//数据库用户名
- private static final String PASSWORD = "";//数据库密码
- /**
- *初始化数据库连接
- */
- public DbManager() throws Exception {
- Class.forName(DRIVER);
- connection = DriverManager.getConnection(URL, USER, PASSWORD);
- statement = connection.createStatement();
- }
- /**
- *执行数据库查询操作
- *@param sql 要执行的SQL语句
- *@return 对应的结果集对象
- */
- public ResultSet query(String sql) throws Exception {
- resultSet = statement.executeQuery(sql);
- return resultSet;
- }
- /**
- *执行数据库增添、删除、修改操作
- *@param sql 要执行的SQL语句
- *@return int 0或1
- */
- public int update(String sql) throws Exception {
- return statement.executeUpdate(sql);
- }
- /**
- *关闭数据库连接
- *@param 无
- *@return void
- */
- public void close() {
- try {
- if (resultSet != null) {
- resultSet.close();
- }
- if (statement != null) {
- statement.close();
- }
- if (connection != null) {
- connection.close();
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
复制代码 转自:http://yuncode.net/code/c_5124a5d1506b186 |
|