登录模块(Jtable+Vector+SpringTemplate+JDDCUtils)
需要的架包:
c3p0-0.9.5.5.jar
spring-context-5.0.2.RELEASE.jar
mchange-commons-java-0.2.19.jar
spring-beans-5.0.2.RELEASE.jar
spring-core-5.0.2.RELEASE.jar
mysql-connector-java-5.1.37-bin.jar
druid-1.0.9.jar
spring-tx-5.0.2.RELEASE.jar
spring-jdbc-5.0.2.RELEASE.jar
commons-logging-1.2.jar
spring-expression-5.0.2.RELEASE.jar
有需要可以提供
Jtable+Vector+SpringTemplate+JDDCUtils
JTable table;
public allinfo() {
//创建表格(每一行都是一个Vector<Object集合>)内容.
Vector<Vector<Object>> vd = new Vector<>();
//连接数据库
JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
//定义sql
String sql = "select * from login";
//创建用户信息users集合
Vector<Object> users = new Vector<>();
//执行sql 获取集合
List<User> maps = template.query(sql, new BeanPropertyRowMapper<User>(User.class));
for (User map : maps) {
Vector<Object> temp = new Vector<>();
temp.add(map.getUsername());
temp.add(map.getPassword());
temp.add(map.getPhone());
temp.add(map.getEmail());
temp.add(map.getAge());
temp.add(map.getDate());
vd.add(temp);
}
//vd.add(users);
//创建表头
Vector<String> vh = new Vector<String>();
vh.add("姓名");
vh.add("年龄");
vh.add("手机号");
vh.add("年龄");
vh.add("邮箱");
vh.add("日期");
//定义默认表结构
final DefaultTableModel dtm = new DefaultTableModel(vd, vh);
//将默认表加入table
table = new JTable(dtm);
this.add(new JScrollPane(table));
this.pack();
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
initComponents();
}
Navicat Lite表设计:
运行结果:
JDBCUtils工具类:
//1.定义成员变量 DataSource
private static DataSource ds;
static {
try {
//1.加载配置文件
Properties pro=new Properties();
pro.load(JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
//2.获取DataSource
ds= DruidDataSourceFactory.createDataSource(pro);
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
/*
获取链接的方法
*/
public static Connection getConnection() throws SQLException {
return ds.getConnection();
}
/*
释放资源
*/
public static void close(Statement stmt,Connection conn)
{
if(stmt!=null)
{
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null)
{
try {
conn.close();//归还链接
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void close(ResultSet rs,Statement stmt, Connection conn)
{
if(rs!=null)
{
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stmt!=null)
{
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null)
{
try {
conn.close();//归还链接
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/*
获取连接池方法
*/
public static DataSource getDataSource()
{
return ds;
}