package demo;

import java.sql.*;

public class StudentDao{
	public void testQuery(String studentname)throws Exception{
		ConnectionFactory factory = ConnectionFactory.getInstance();
		Connection con = factory.getConnection();
		String sql = "select * from student where studentname = ?";
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1,studentname);
		ResultSet rs = pstmt.executeQuery();
		if(rs.next()){
			String gender = rs.getString("gender");
			System.out.println("gender :"+gender);
		}

		//應該釋放資源，以上代碼規范不好，請注意！
	}

	public static void main(String[] args)throws Exception{
		StudentDao dao = new StudentDao();
		dao.testQuery("km");
	}
}