java 查询 代码_Java连接数据库完整代码 查找和插入

packagetest;importjava.io.InputStream;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.util.Properties;importorg.junit.Test;public classMain {private staticString driver;private staticString url;private staticString username;private staticString password;static{try{

InputStream is= Main.class.getResourceAsStream("/jdbc.properties");

Properties prop= newProperties();

prop.load(is);

driver= prop.getProperty("jdbc.driver");

url= prop.getProperty("jdbc.url");

username= prop.getProperty("jdbc.username");

password= prop.getProperty("jdbc.password");//将JDBC驱动加载到JVM中

Class.forName(driver);

}catch(Exception e) {

e.printStackTrace();

}

}/*** 演示JDBC

**/@Testpublic void insert() throwsException {

String sql= "insert into tb_user values(null,?,?)";

Connection conn=DriverManager.getConnection(url, username, password);

PreparedStatement pst=conn.prepareStatement(sql);

pst.setString(1, "李四");

pst.setInt(2, 30);

pst.executeUpdate();

pst.close();

conn.close();

}/*** 查询

**/@Testpublic void query() throwsException {

String sql= "select * from tb_user where id>=?";

Connection conn=DriverManager.getConnection(url, username, password);

PreparedStatement pst=conn.prepareStatement(sql);

pst.setInt(1, 1);

ResultSet rs=pst.executeQuery();while(rs.next()) {int id = rs.getInt("id");

String name= rs.getString("name");int age = rs.getInt("age");

System.out.printf("id:%d, name:%s, age:%d\n", id, name, age);

}

rs.close();

pst.close();

conn.close();

}/*** 获得文件的路径

**/@Testpublic void test1() throwsException {//从类路径根目标查找

String path = this.getClass().getClassLoader().getResource("jdbc.properties").toURI().getPath();

System.out.println(path);

}

@Testpublic void test2() throwsException {//从当前目标查找，/表示根目录

String path = this.getClass().getResource("/jdbc.properties").toURI().getPath();

System.out.println(path);

}

}