jdbc链接mysql程序

数据库名为test，表名为user，表中的内容如下

工程中需要加入mysql驱动包 mysql-connector-java-5.1.25，下载地址：点击跳转

工程目录结构如下

代码如下

String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/test";
String user="root";
String password="12345678";
		
Connection connection=null;
PreparedStatement preparedStatement=null;
ResultSet resultSet=null;
try {
	Class.forName(driver);
	connection=DriverManager.getConnection(url,user,password);
	String sql="select * from user";
	preparedStatement=connection.prepareStatement(sql);
	resultSet=preparedStatement.executeQuery();
	while(resultSet.next()){
		System.out.println(
		"id:"+resultSet.getInt("id")+
		"--name:"+resultSet.getString("name")+
		"--password:"+resultSet.getString("password")+
		"--email;"+resultSet.getString("email"));
	}
} catch (Exception e) {
	e.printStackTrace();
}finally{
	if(resultSet!=null){
		try {
			resultSet.close();					
		} catch (Exception e2) {
			e2.printStackTrace();
		}
	}
	if(preparedStatement!=null){
		try {
			preparedStatement.close();
		} catch (Exception e2) {
			e2.printStackTrace();
		}
	}
	if(connection!=null){
		try {
			connection.close();
		} catch (Exception e2) {
			e2.printStackTrace();
		}
	}
}

结果如下