Statement语句实现数据库的增删改查操作

来源：互联网发布：李宁在淘宝有多少店编辑：程序博客网时间：2024/06/04 09:36

DButil.java

import java.sql.DriverManager;import java.sql.SQLException;import java.util.Properties;import com.mysql.jdbc.Connection;public class DButil {/* * 打开数据库 */    private static String driver;//连接数据库的驱动    private static String url;    private static String username;    private static String password;        static {    driver="com.mysql.jdbc.Driver";//需要的数据库驱动    url="jdbc:mysql://localhost:3306/test";//数据库名路径    username="root";    password="root";    }public static Connection open(){try {Class.forName(driver);return (Connection) DriverManager.getConnection(url,username, password);} catch (Exception e) {System.out.println("数据库连接失败！");// TODO Auto-generated catch blocke.printStackTrace();}//加载驱动return null;}        /* * 关闭数据库 */public static void close(Connection conn){if(conn!=null){try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}

TestData.java

import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import com.mysql.jdbc.Connection;import com.mysql.jdbc.Statement;public class TestData {public static void main(String[] args) {// TODO Auto-generated method stub         // CreateTable();//insert();//update();//delete();query();//Query()}static void CreateTable(){Connection conn=DButil.open();String sql="create table UserTable(id int not null primary key auto_increment,name varchar(20) not null)";try {Statement stmt=(Statement) conn.createStatement();stmt.execute(sql);//执行该条语句} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {DButil.close(conn);}}static void insert(){Connection conn=DButil.open();String sql="insert into UserTable(id,name) value (1001,'zhangsan'),(1002,'lisi') ,(1003,'wangwu'),(1004,'liliu')";try {Statement stmt=(Statement) conn.createStatement();stmt.executeUpdate(sql);//执行更新该表} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {DButil.close(conn);}}static void update(){Connection conn=DButil.open();String sql="update UserTable set name='Haige' where id=1003";try {Statement stmt=(Statement) conn.createStatement();stmt.executeUpdate(sql);//执行更新该表} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {DButil.close(conn);}}static void delete(){Connection conn=DButil.open();String sql="delete from UserTable where id=1004";try {Statement stmt=(Statement) conn.createStatement();stmt.executeUpdate(sql);//执行更新该表} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {DButil.close(conn);}}static void query(){Connection conn=DButil.open();String sql="select * from UserTable";try {Statement stmt=(Statement) conn.createStatement();ResultSet rs=stmt.executeQuery(sql);//执行查询该表while(rs.next()){int id=rs.getInt(1);String name=rs.getString(2);System.out.println(id+","+name);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {DButil.close(conn);}}/* * 集合类封装输出查询结果 */static List<User> Query(){Connection conn=DButil.open();String sql="select * from UserTable";try {Statement stmt=(Statement) conn.createStatement();ResultSet rs=stmt.executeQuery(sql);//执行查询该表List<User> list=ArrayList<User>();while(rs.next()){int id=rs.getInt(1);String name=rs.getString(2);//System.out.println(id+","+name);User user=new User();user.setId(id);user.setName(name);list.add(user);}System.out.println(list);return list;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {DButil.close(conn);}return null;}}

User.java

public class User { private int id; private String name;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;} @Overridepublic String toString() {// TODO Auto-generated method stubreturn id+":"+name;}}

操作过程截图：

0 0