数据库操作(crud)

使用JDBC连接数据库

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Conn {
    private static final String URL="jdbc:mysql://127.0.0.1:3307/wangben?useUnicode=true&characterEncoding=utf-8";
    private static final String USER="root";
    private static final String PASSWORD="123456";

            private static Connection conn=null;

            static {
            try {
                         //1.加载驱动程序
                         Class.forName("com.mysql.jdbc.Driver");
                        //2.获得数据库的连接
                        conn=DriverManager.getConnection(URL, USER, PASSWORD);
                    } catch (ClassNotFoundException e) {
                      e.printStackTrace();
                   } catch (SQLException e) {
                        e.printStackTrace();
                    }
          }
             public static Connection getConnection(){
                return conn;
      }
 }

查询数据库

import java.sql.*;

public class Renewal {
    static Connection conn;
    static PreparedStatement pstmt;
    static ResultSet res;
    public Connection getConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3307/wangben", "root", "123456");
        } catch (Exception e) {

        }
        return conn;
    }

    public static void main(String[] args) {
        Renewal c = new Renewal();
        conn = c.getConnection();
        try{
            pstmt = conn.prepareStatement("select * from user");
            res = pstmt.executeQuery();
            System.out.println("查询数据");
            while(res.next()){
                String id = res.getString(1);
                String username = res.getString("username");
                String userpassword = res.getString("userpassword");
                System.out.println("编号"+id);
                System.out.println("姓名："+username);
                System.out.println("密码："+userpassword);
            }


        } catch (Exception e) {
            e.printStackTrace();
        }
    }

}

添加数据

 //添加数据
            pstmt = conn.prepareStatement("insert into user(username,userpassword) values(?,?)");
            pstmt.setString(1,"玛卡巴卡");
            pstmt.setString(2,"乌西迪西");
            pstmt.executeUpdate();

更新数据

  pstmt = conn.prepareStatement("update user set password"+"= where id=?");
            pstmt.setString(1,"hehe");
            pstmt.setInt(2,1);
            pstmt.executeUpdate();

删除数据

  Statement stmt = conn.createStatement();
            stmt.executeUpdate("delete * from user ");