Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package test;
- import java.sql.*;
- public class TestMysql {
- public static void main(String[] args) {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection cnt = DriverManager.getConnection("jdbc:mysql://localhost/app_server", "app_server", "WVezBsbqNPCSMMyN");
- // Method 1
- Statement stm = cnt.createStatement();
- ResultSet rss = stm.executeQuery("SELECT * FROM `kashima_bangumi`");
- while (rss.next()) {
- System.out.printf("%s %s %d\n", rss.getString("btitlecn"), rss.getString("btitlejp"), rss.getInt("bwa"));
- }
- // Method 2
- PreparedStatement pstm = cnt.prepareStatement("SELECT `bid`, `btitlecn`, `btitlejp`, `bwa` FROM `kashima_bangumi` WHERE `btitlecn` like ? OR `btitlejp` like ? LIMIT ?, 10;");
- pstm.setString(1, "%锟斤拷%");
- pstm.setString(2, "%锟斤拷%");
- pstm.setInt(3, 0);
- // pstm.executeUpdate();// 没锟叫凤拷锟斤拷值
- rss = pstm.executeQuery();
- while (rss.next()) {
- System.out.printf("%s %s %d\n", rss.getString("btitlecn"), rss.getString("btitlejp"), rss.getInt("bwa"));
- }
- } catch (Exception e) {
- e.printStackTrace();
- } finally {
- }
- }
- }
Add Comment
Please, Sign In to add comment