dengru.java

快速有效的登录界面

package com.tt;

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

	import com.tt.DBConnection;


	public class dengru  extends DBConnection{
		Connection conn;
		


		public boolean checkid(String id) {
			boolean result = false;
			ResultSet rs;
			DBConnection DBC = new DBConnection();
			conn=DBC.connectionDB();
			
				String sql = "select id from student where id='"+id+"'";
				try {
					Statement ps= conn.createStatement();
					rs=ps.executeQuery(sql);
					if(rs.next()) {
							result=true;
						}
							
				} catch (Exception e) {
					e.printStackTrace();
					result=false;
				}

			return result;
		}


		public String getPassword(String id) {
			String password = null;
			DBConnection DBC = new DBConnection();
			conn=DBC.connectionDB();
			ResultSet rs = null;
			String sql = "select password from student where id='"+id+"'" ;
			try {
				Statement ps=conn.createStatement();
				rs=ps.executeQuery(sql);
				while (rs.next()) {
					password = rs.getString("password");
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		

		return password;
	 }


	}