JDBC连接数据库并实现数据库操作
package com.thunisoft.yhan.daos;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class BaseDao {
protected Connection getConn() {
String url = "jdbc:ArteryBase://localhost:5432/test?ApplicationName=user&Charset=utf8";
String username = "sa";
String password = "test";
String driver = "com.thunisoft.ArteryBase.Driver";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, username, password);
return conn;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
protected void closeAll(ResultSet rs, Connection conn, Statement s, PreparedStatement ps) {
try {
if (rs != null) {
rs.close();
}
if (conn != null) {
conn.close();
}
if (s != null) {
s.close();
}
if (ps != null) {
ps.close();
}
} catch (SQLException e) {