JDBC基本语句

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

public class TestJDBC {
    //通过参数，插入一条记录
    public static void testInsert(String username, String pwd, String status, String qq, String time) {
    //声明连接对象，语句对象
        Connection conn = null;
        PreparedStatement pstmt= null;
        try {
    //加载驱动类
        Class.forName("com.mysql.jdbc.Driver");
    //获得连接
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf8","root","123");
    //获得预编译语句对象，PreparedStatement, SQL语句中使用?占位
        String sql = "insert into user values(?,?,?,?,?)";
        pstmt = conn.prepareStatement(sql);
    //对占位设置具体值
        pstmt.setString(1, username);
        pstmt.setString(2, pwd);
        pstmt.setString(3, status);
        pstmt.setString(4, qq);
        pstmt.setString(5, time);
    //执行更新
        pstmt.executeUpdate();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch(SQLException e) {
            e.printStackTrace();
        } finally {
    //关闭资源
            if(pstmt!=null) {
                try {
                    pstmt.close();
                } catch(SQLException e) {
                e.printStackTrace();
                }
            }
            if(conn!=null) {
                try {
                    conn.close();
                } catch(SQLException e) {
                e.printStackTrace();
                }
            }
        }
    }
    
    public static void main(String[] args) {
        testInsert("EdwardLi","1","1","352455009","2017-11-08");
    }
}

 

转载于:https://www.cnblogs.com/edwardli/p/7805742.html