sql.java

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 {

		}
	}

}