jdbc简单使用

Class.forName("com.mysql.cj.jdbc.Driver");//这是连接mysql数据库的驱动
java.sql.Connection conn = java.sql.DriverManager.getConnection("jdbc:mysql://10.xx.xx.xxx:3306/test", "root", "123456");

String sql = "update t_kafa_logs set  remark='2',  updated_at=?  where uniqueid='hgcsncdkssfjfhshfjshfsj'";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
ps.executeUpdate();//更新

/*ResultSet rs = ps.executeQuery();//查询处理
while(rs.next()){
    System.out.println(rs.getInt(1));
    System.out.println(rs.getString("username"));
    System.out.println(rs.getString("password"));
}//执行插入语句
rs.close();*/

ps.close();

conn.close();