摘要:java 連 mysql + 查詢資料表
eclipse的lib放入mysql-connector-java-5.1.29-bin.jar
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=Big5",
"root","admin");
System.out.println("Connected to the database");
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
String sql = "select * from sakila.actor";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
System.out.print("actor_id = "+ rs.getString("actor_id"));
System.out.print(" ; first_name = "+ rs.getString("first_name"));
System.out.println(" ; last_name = "+ rs.getString("last_name"));
}
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
}
