package com.birds.chart.demo;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.LinkedList;
public class DBTools {
private java.sql.Connection connection;
private java.sql.PreparedStatement preparedStatement;
public DBTools() {
try {
connection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/goldtest", "root", "admin123");
} catch (SQLException e) {
e.printStackTrace();
}
}
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (Exception e) {
e.printStackTrace();
}
}
public void close() {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public ResultSet executeQuery(String sql, LinkedList<Object> params) {
try {
preparedStatement = connection.prepareStatement(sql);
if (params != null) {
int i = 1;
for (Object p : params) {
preparedStatement.setObject(i++, p);
}
}
return preparedStatement.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public static void main(String[] args) {
LinkedList<Object> params = new LinkedList<Object>();
params.add("HOME");
DBTools tool = new DBTools();
ResultSet rs = tool.executeQuery("SELECT * FROM users where Type= ? order by UpdateTime limit 100", params);
try {
System.err.println(rs.next());
} catch (SQLException e) {
e.printStackTrace();
}
tool.close();
}
}
JAVA JDBC 连接Mysql 代码。
最新推荐文章于 2024-07-24 22:38:07 发布