package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * sql传参用法
 * @author Administrator
 *
 */
public class preparedStatement {

	public static void main(String[] args) {
		//连接数据库的URL
	    String url = "jdbc:mysql://localhost:3306/student"; // jdbc协议:数据库子协议:主机:端口/连接的数据库   //
	    String user = "root";//用户名
	    String password = "root";//密码
		try {
			//1.加载驱动
			Class.forName("com.mysql.jdbc.Driver");
			//2.创建连接
			Connection conn=DriverManager.getConnection(url,user, password);
			//3.使用PreparedStatement方式执行SQL语句
			PreparedStatement pt=conn.prepareStatement("select * from studentInfo where stuName=? and sno=?");	//conn是建立连接的实例
			//给SQL语句问好赋值
			pt.setString(1, "张三");
			pt.setInt(2, 10001);
			//5.executeQuery执行sql语句，进行查询操作并返回结果集
			ResultSet rs = pt.executeQuery();
			//循环输出结果集
			while(rs.next()) {
				String stuName=rs.getString("stuName");
				int sno=rs.getInt("sno");
				String sclass=rs.getString("sclass");
				System.out.println("班级："+sclass+"  姓名："+stuName+"  学号："+sno);
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}