别整那么多废话,直接上代码;
package cn.mike.javase.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBC_Connection {
public static void main(String[] args) {
Connection conn = null;// connection
PreparedStatement preState = null;// prepared statement
ResultSet resultSet = null;// resultset
try {
// load driver
Class.forName("com.mysql.jdbc.Driver");
// get connection
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ibatis_test", "root", "3713");
/* sql statement */
String querySql = "SELECT * FROM USERS WHERE USERNAME = ?";
// prepare statement
preState = conn.prepareStatement(querySql);
// set parameter
preState.setString(1, "michael");
// execute query
resultSet = preState.executeQuery();
// iterate result set
while (resultSet.next()) {
System.out.println(resultSet.getString("id") + "\t" + resultSet.getString("username") + "\t" + resultSet.getString("password"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
// close streams seperately
try {
if (null != resultSet) {
resultSet.close();
}
if (null != preState) {
preState.close();
}
if (null != conn) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}