package com.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.List;
import java.util.Properties;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
public class testmain {
public static void main(String[] args) throws Exception
{
//读取数据库链接信息
Properties pro=new Properties();
pro.load(testmain.class.getResourceAsStream("/jdbcconnection.properties"));
String url=pro.getProperty("mysql.url");
String driver=pro.getProperty("mysql.driver");
String user=pro.getProperty("mysql.user");
String password=pro.getProperty("mysql.password");
//加载数据库驱动
Class.forName(driver);
//获取数据库链接
Connection con=DriverManager.getConnection(url, user, password);
//查询(可查询单个和多个对象)
String sql="select * from student";
QueryRunner query=new QueryRunner();
BeanListHandler<Student> handle=new BeanListHandler<Student>(Student.class);
List<Student> student=query.query(con, sql, handle);
for(Student s:student)
{
System.out.println(s);
}
//增加对象
String addsql="insert into Student(id,username,gender,age,phone) values(?,?,?,?,?)";
int i=query.update(con, addsql, 26,"test3","nan",22,"12546");
System.out.println(i);
//删除对象
String deletesql="delete from student where id=23";
i=query.update(con,deletesql);
System.out.println(i);
//修改对象
String updatesql="update student set username='aaa' where id=25";
i=query.update(con,updatesql);
System.out.println(i);
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.List;
import java.util.Properties;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
public class testmain {
public static void main(String[] args) throws Exception
{
//读取数据库链接信息
Properties pro=new Properties();
pro.load(testmain.class.getResourceAsStream("/jdbcconnection.properties"));
String url=pro.getProperty("mysql.url");
String driver=pro.getProperty("mysql.driver");
String user=pro.getProperty("mysql.user");
String password=pro.getProperty("mysql.password");
//加载数据库驱动
Class.forName(driver);
//获取数据库链接
Connection con=DriverManager.getConnection(url, user, password);
//查询(可查询单个和多个对象)
String sql="select * from student";
QueryRunner query=new QueryRunner();
BeanListHandler<Student> handle=new BeanListHandler<Student>(Student.class);
List<Student> student=query.query(con, sql, handle);
for(Student s:student)
{
System.out.println(s);
}
//增加对象
String addsql="insert into Student(id,username,gender,age,phone) values(?,?,?,?,?)";
int i=query.update(con, addsql, 26,"test3","nan",22,"12546");
System.out.println(i);
//删除对象
String deletesql="delete from student where id=23";
i=query.update(con,deletesql);
System.out.println(i);
//修改对象
String updatesql="update student set username='aaa' where id=25";
i=query.update(con,updatesql);
System.out.println(i);
}
}