JDBC的入门

最新推荐文章于 2024-09-15 08:03:51 发布

一滴风

最新推荐文章于 2024-09-15 08:03:51 发布

阅读量146

点赞数

文章标签：数据库 java jdbc

本文链接：https://blog.csdn.net/qq_33116637/article/details/51761717

版权

JDBC 即Java Data Base Connectivity,java数据库连接；

步骤一：建立JavaBean

public static Connection getCon(){
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/chatrecord";
        String username = "root";
        String password = "";
        Connection conn = null;
        try {
            Class.forName(driver);
            conn = (Connection) DriverManager.getConnection(url, username, password);
        }
        catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }

步骤二：建立与数据库的连接

public static Connection getCon(){
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/chatrecord";
        String username = "root";
        String password = "";
        Connection conn = null;
        try {
            Class.forName(driver);
            conn = (Connection) DriverManager.getConnection(url, username, password);
        }
        catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }

步骤三：对数据进行增删改查（以增为例）

 public static int insert(MessageBean message){
        
        Connection con = getCon();
        String sql = "insert into chatrecord(id,message) values (?,?,?);";
        PreparedStatement ps = null;
        int i = 0;
        try{
            ps = (PreparedStatement)con.prepareStatement(sql);
            ps.setString(1, message.getId());
            ps.setString(2, message.getContent());
            i = ps.executeUpdate();
            ps.close();
            con.close();
        }catch(SQLException e){
            e.printStackTrace();
        }
}