PreparedStatement 连接mysql

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
 * PreparedStatement
 *
 */
public class JdbcDemo2 {
	//中文乱码?useUnicode=true&characterEncoding=UTF-8
	private static final String URL = "jdbc:mysql://localhost:3306/stores?useUnicode=true&characterEncoding=UTF-8";
	private static final String USER = "root";
	private static final String PASSWORD = "123";

	public static void main(String[] args) throws Exception {
		// 1.加载驱动包classLoder,知道连接的是那种数据库
		// --mysql-connector-->com.mysql.jdbc-->Driver.class-->local:
		// com.mysql.jdbc.Driver
		Class.forName("com.mysql.jdbc.Driver");
		// 2.获取数据库连接 （url,user,password 设置常量）
		Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);

		// PreparedStatement =?预置参数，
		String sql = "SELECT DEPTNO,DNAME,LOC FROM DEPT where deptno=?";
		// 预编译语句，参数化语句
		PreparedStatement stat = conn.prepareStatement(sql);
		// 设置参数,不管什么类型都Object，索引从1开始
		stat.setObject(1, "40");

		// 3.执行数据库事务,增删改 update，查query
		ResultSet rs = stat.executeQuery();// 不需要参数

		// 4.处理结果集
		while (rs.next()) {
			Integer deptNo = rs.getInt("DEPTNO");
			String dName = rs.getString("DNAME");
			String loc = rs.getString("LOC");
			System.out.println(deptNo + "-" + dName + "-" + loc);
		}
		// 5.关闭数据库
		rs.close();
		stat.close();
		conn.close();
	}
}