package com.hanqi.test;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.hanqi.util.JdbcConnectionUtil;
public class Test {
private static Connection con; //链接数据库
private static PreparedStatement pste;// 执行sql语句
private static ResultSet rs; //执行返回结果
public static void main(String[] args) {
init();
String sql = "select * from appuser";
try {
pste = con.prepareStatement(sql);// 执行sql语句
rs = pste.executeQuery();//执行完的返回结果
while(rs.next()) {
System.out.println(rs.getInt("id"));
System.out.println(rs.getString("username"));
System.out.println(rs.getString("password"));
System.out.println(rs.getString("realname"));
System.out.println(rs.getDate("createtime"));
System.out.println("================================");
}
} catch (SQLException e) {
e.printStackTrace();
}
close();
}
public static void init() {
con = JdbcConnectionUtil.getConnection();
}
public static void close() {
JdbcConnectionUtil.destroy(con,pste,rs);
}
}