SQL数据库连接参数设置如何打开

SQL数据库连接参数设置如何打开

private Connection conn = null;
private PreparedStatement pstmt = null;
private ResultSet rs = null;

try {
String sql = "INSERT INTO \"UserInfo\" (\"MESSAGE\") VALUES (?);";
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection(dbURL, userName, password);
pstmt = conn.prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS);
pstmt.setString(1, msg);
pstmt.execute();
rs = pstmt.getGeneratedKeys();

if (rs.next()) {
userID = rs.getObject(1).toString();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}

if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}

if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

是要这个吗？

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息