jdbc mysql查询显示图片_JDBC方式从数据库中查询数据并显示

packageyang.mybatis.dao;importyang.mybatis.domain.User;import java.sql.*;importjava.util.ArrayList;importjava.util.List;/*** Created by yangshijing on 2017/11/10 0010.*/

public classUserDaoTest {public ListgetAll(){

List Users = new ArrayList();

Connection connection= null;

PreparedStatement preparedStatement= null;

ResultSet resultSet= null;try{

String driverClass= "com.mysql.jdbc.Driver";

String url= "jdbc:mysql:///mydb";

String user= "root";

String pass= "1234";

Class.forName(driverClass);

connection=DriverManager.getConnection(url, user, pass);

String sql= "SELECT user_name, id, age, password FROM myuser";

preparedStatement=connection.prepareStatement(sql);

resultSet=preparedStatement.executeQuery();while(resultSet.next()){

String user_name= resultSet.getString(1);int id = resultSet.getInt(2);int age = resultSet.getInt(3);

String password= resultSet.getString(4);

User userl= newUser(user_name,id,age,password);

Users.add(userl);

}

}catch(Exception e) {

e.printStackTrace();

}finally{try{if(resultSet != null){

resultSet.close();

}

}catch(SQLException e) {

e.printStackTrace();

}try{if(preparedStatement != null){

preparedStatement.close();

}

}catch(SQLException e) {

e.printStackTrace();

}try{if(connection != null){

connection.close();

}

}catch(SQLException e) {

e.printStackTrace();

}

}returnUsers;

}

}