java 连接数据库查询_JAVA连接数据库，查询功能怎么写

展开全部

public class JdbcNoarg {

//查询一行数636f707962616964757a686964616f31333363353765据

public void getQueryNoargOne(){

JdbcMysqlPool jdbc = new JdbcMysqlPool();

Connection con=null;

Statement st = null;

String sql;

ResultSet rst = null;

try {

//获取数据库连接

con = jdbc.getConnection();

//在连接里打开一条通道createStatement，返回Statement对象

st = con.createStatement();

sql = "select *from student";

//把我们想要结果sql语句发送给数据库，数据库返回的数据用java ResultSet来接收

rst= st.executeQuery(sql);

//获取结果集的第一行数据9

rst.first();

//获取结果集指定列的数据

String name = rst.getString("name");

String interest = rst.getString("interest");

System.out.println("name:"+name+";interest:"+interest);

} catch (Exception e) {

e.printStackTrace();

}finally {

try {

if(rst!=null)

rst.close();

if(st!=null)

st.close();

if(con!=null)

con.close();

} catch (Exception e2) {

e2.printStackTrace();

}

}

}