studentdao.java

来自「Ajax的使用方法」· Java 代码 · 共 25 行

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");
	}
}