package Dao;
import java.sql.*;
public class User {
	private Connection con=null;
	private Statement st=null;
	private PreparedStatement ps=null;
	private ResultSet rs=null;
	public final static String driver="com.mysql.jdbc.Driver";
	public final static String uri="jdbc:mysql://localhost:3306/News";
	public final static String name="root";
	public final static String password="123456";
	
	//������ݿ�����
	public void getConn(){
		try{
			Class.forName(driver); //��������
			con=DriverManager.getConnection(uri, name, password);
			System.out.println("��ݿ�������");
		}
		catch (ClassNotFoundException e) {
			// TODO: handle exception
			System.out.println("����δ�ҵ�"+e.toString());
		}
		catch (SQLException e) {
			// TODO: handle exception
			System.out.println("���Ӷ��󴴽�ʧ��"+e.toString());
		}
	}
	
	//������ݱȶ�
	 public boolean findNamePassword(String name,String pwd){
		 boolean flag=false;
		 String sql="select * from User where name=? and pwd=?";
		 try{
			 ps=con.prepareStatement(sql);
			 ps.setString(1,name);
			 ps.setString(2, pwd);
			 rs=ps.executeQuery();
			 if (rs.next()) {
				System.out.println("�û�����");
				flag=true;
			}
			 else{
				 System.out.println("�û�������");
				 flag=false;
			 }
		 }
		 catch (SQLException e) {
			// TODO: handle exception
			 e.printStackTrace();
		}
		 return flag;
	 }
	 
	 //��ȡ�û���
	 public boolean findName(String name){
		 boolean flag=false;
		 String sql="select * from User where name=?";
		 try{
			 ps=con.prepareStatement(sql);
			 ps.setString(1,name);
			 rs=ps.executeQuery();
			 if(rs.next()){
				 System.out.println("�û�����");
				 flag=true;
			 }
			 else{
				 System.out.println("�û�������");
				 flag=false;
			 }
		 }
		 catch (SQLException e) {
				// TODO: handle exception
				 e.printStackTrace();
			}
			 return flag;
		   
	 }
	 
	 //��ѯ�û����
	 public boolean findID(int uid){
		 boolean flag=false;
		 String sql="select * from User where uid=?";
		 try{
			 ps=con.prepareStatement(sql);
			 ps.setInt(1,uid);
			 rs=ps.executeQuery();
			 if(rs.next()){
				 System.out.println("uid����");
				 flag=true;
			 }
			 else{
				 System.out.println("uid������");
				 flag=false;
			 }
		 }
		 catch (SQLException e) {
				// TODO: handle exception
				 e.printStackTrace();
			}
			 return flag;
		   
	 }
	 
	 //�û�ע��
	 public int insertUser(String name,String pwd,String mail){
		 int i=0;
		 String sql="insert into User(name,pwd,mail)values(?,?,?)";
		 try{
			 ps=con.prepareStatement(sql);
			 ps.setString(1, name);
			 ps.setString(2, pwd);
			 ps.setString(3, mail);
			 i=ps.executeUpdate();
		 }
		 catch (SQLException e) {
			// TODO: handle exception
			 e.printStackTrace();
		}
		 return i;
	 }
	 
	 //�û�ע��
	 public void delete(int uid){
		 String sql="delete from User where uid=? ";
		 try{
			 ps=con.prepareStatement(sql);
			 ps.setInt(1, uid);
			 ps.executeUpdate();
		 }
		 catch (SQLException e) {
			// TODO: handle exception
			 e.printStackTrace();
		} 
	 }
	 //�û���Ϣ����
	 public void update(String name,String pwd){
		 String sql="update User set pwd=? where name=?";
		 try{
			 ps=con.prepareStatement(sql);
			 ps.setString(1, pwd);
			 ps.setString(2, name);
			 ps.executeUpdate();
			 System.out.println("��Ϣ���³ɹ�");
		 }
		 catch (SQLException e) {
			// TODO: handle exception
			 e.printStackTrace();
		} 
	 }
}