jdbc

来源:互联网 发布:政府网站改版优化文案 编辑:程序博客网 时间:2024/06/13 15:02
1,jdbc为连接数据库的一个方法,
如:Class.forName("org.git.mysql.Driver");
Connection connection=DriverManager.getConnection("mysql:jdbc://127.0.0.1:3306/test","xcl","xcl");
Statement statement=connection.createStatement();
ResultSet resultSet=statement.executeQuery("select * from testuser");
while(resultSet.next()){
resultSet.getString("name");
}
statement.execute("insert into testuser('aa') values('aa')");
statement.executeUpdate("update testuser set aa='1' where id=3");
statement.executeUpdate("delete from testuser");