数据信息查询

package com.myjdbc;
import	java.sql.Connection;
import java.sql.ResultSet;
import  java.sql.SQLException;
import  java.sql.PreparedStatement;
import  java.sql.Statement;

public class QueryStudent {
	DBConnection	onecon = new DBConnection();
	Connection		con = null;
	private Statement stmt = null;
	private PreparedStatement pstmt = null;	
	
	
	public void getOneStudent(String sno) {
		// TODO Auto-generated constructor stub
		con = onecon.getConnection();
		ResultSet rs;
		try {
			pstmt = con.prepareStatement("select * from student where sno=?");
			pstmt.setString(1, sno);
			rs = pstmt.executeQuery();
			while(rs.next())
			{
				System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4));
			}
			stmt.close();
			con.close();
		} catch (SQLException e) {
			// TODO: handle exception
			System.out.println("数据库读异常"+e);
		}
	}

	public void getAllstudent(){
		con = onecon.getConnection();
		ResultSet rs;
		
		try {
			stmt = con.createStatement();
			rs = stmt.executeQuery("select * from student");
			while(rs.next())
			{
				System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4));
			}
			stmt.close();
			con.close();
		} catch (SQLException e) {
			// TODO: handle exception
			System.out.println("数据库读异常"+e);
		}
		
	}
		
	public static void main(String[] args)
	{
		QueryStudent qs = new QueryStudent();
		qs.getAllstudent();
		qs.getOneStudent("20190810");
	}
	
}