package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class jdcb {

	public static void main(String[] args) {
		//1.加载驱动
		try {
			Class.forName("com.mysql.jdbc.Dirver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		//2.建立连接
		//数据库访问地址
		String url = "jdbc:mysql://localhost:3306/student";
		//数据库用户名
		String name = "root";
		//数据库密码
		String pwd = "root";
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn=DriverManager.getConnection(url,name,pwd);
		//创建执行sql语句状态
		Statement stu =  conn.createStatement();
		//4.撰写sql语句
		String sql = "select * from studentinfo;";
		//5.执行sql语句，并返回结果集
		stu.executeQuery(sql);
		ResultSet rs = stu.executeQuery(sql);
		//遍历结果集，获取结果
		while(rs.next()) {
			String StuName = rs.getNString("StuName");	//获取StuName列值
			int sno = rs.getInt("sno");					//获取sno列值
			String sclass = rs.getNString("sclass");	//获取sclass列值
			//输出学生信息
			System.out.println("学生姓名："+StuName+"学号"+sno+"班级"+sclass);
		}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}