jdbc连接mysql数据库url在哪看_jdbc联接数据库,看main方法在哪里写?

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DBConnection {

private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";

// 最后的orcl是数据库库名

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";

// 用户名

private static final String USER = "scott";

// 密码

private static final String PASSWORD = "tiger";

Connection conn;

Statement stmt;

ResultSet res;

public DBConnection() {

try {

Class.forName(DRIVER);

} catch (ClassNotFoundException ex) {

ex.printStackTrace();

}

}

public boolean getConnection() {

try {

conn = DriverManager.getConnection(URL, USER, PASSWORD);

return true;

} catch (SQLException ex) {

ex.printStackTrace();

return false;

}

}

public int execUpdate(String sql) {

int rows = 0;

try {

stmt = conn.createStatement();

rows = stmt.executeUpdate(sql);

} catch (SQLException ex) {

ex.printStackTrace();

}

return rows;

}

public ResultSet execResultSet(String sql) {

try {

stmt = conn.createStatement();

res = stmt.executeQuery(sql);

return res;

} catch (SQLException ex) {

ex.printStackTrace();

return null;

}

}

public void close() {

if (res != null) {

try {

res.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

}

if (stmt != null) {

try {

stmt.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

}

if (conn != null) {

try {

conn.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

}

}

public static void main(String[] args) {

DBConnection db = new DBConnection();

// 连接数据库

db.getConnection();

// 执行更新语句

String sql1 = "update table1 set name=\"123\"";

int num1 = db.execUpdate(sql1);

System.out.println("有" + num1 + "条记录更新完成");

// 执行查找语句

String sql2 = "select * from table1";

ResultSet resultSet = db.execResultSet(sql2);

try {

while (resultSet.next()) {

String name = resultSet.getString("name");

System.out.println("name=" + name);

}

} catch (SQLException e) {

e.printStackTrace();

}

// 关闭数据库

db.close();

}

}

取消

评论