import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Connect {
public static void main(String[] args) {
try {
String driver = "com.mysql.jdbc.Driver";
String server = "localhost";
String dbname = "test";
String url = "jdbc:mysql://" + server + ":3306/" + dbname
+ "?useUnicode=true&characterEncoding=EUC_JP";
String user = "root";
String password = "";
Class.forName(driver);
Connection con = DriverManager.getConnection(url, user, password);
Statement stmt = con.createStatement();
String sql = "select * from testtable";
ResultSet rs = stmt.executeQuery(sql);
String NAME = null;
int AGE = 0;
while(rs.next()){
NAME = rs.getString("NAME");
AGE = rs.getInt("AGE");
System.out.print("名前:" + NAME + "\t");
System.out.println(AGE + "歳です。");
}
rs.close();
stmt.close();
con.close();
}catch(SQLException e){
System.err.println("データベース接続に失敗");
e.printStackTrace();
}catch(ClassNotFoundException ex){
System.err.println("指定されたクラスが見つからない");
ex.printStackTrace();
}
}