实现注册，并在数据库中体现

package com.yychatserver.controller;

import java.nio.channels.ClosedByInterruptException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;

public class YychatDbUtil {

public static final String MYSQLDRIVER="com.mysql.jdbc.Driver";
public static final String URL="jdbc:mysql://127.0.0.1:3306/yychat?useUnicode=true&characterEncoding=UTF-8";
public static final String DBUSER="root";
public static final String DBPASS="";


public static void loadDriver() {
	try {
		Class.forName(MYSQLDRIVER);
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	}
}


public static Connection getConnection() {
	loadDriver();
	Connection conn=null;
	try {
		conn=DriverManager.getConnection(URL, DBUSER,DBPASS);
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return conn;
}


public static void addUser(String userName,String passWord) {
	Connection conn=getConnection();
	
	String user_Login_Sql="insert into user(username,password,registertimestamp) values(?,?,?)";
	PreparedStatement ptmt=null;
	try {
		ptmt=conn.prepareStatement(user_Login_Sql);
		ptmt.setString(1, userName);
		ptmt.setString(2, passWord);
		
		Date date=new Date();
		java.sql.Timestamp timestamp=new java.sql.Timestamp(date.getTime());
		ptmt.setTimestamp(3, timestamp);

		
		int count=ptmt.executeUpdate();
		
	} catch (SQLException e) {
		e.printStackTrace();
	}finally {
		closeDB(conn,ptmt);
	}		
}


public static boolean seekUser(String userName) {
	boolean seekUserResult=false;
	Connection conn=getConnection();
	
	String user_Login_Sql="select * from user where username=?";
	PreparedStatement ptmt=null;
	ResultSet rs=null;
	try {
		ptmt=conn.prepareStatement(user_Login_Sql);
		ptmt.setString(1, userName);
		
		
		rs=ptmt.executeQuery();
		
		seekUserResult=rs.next();
	} catch (SQLException e) {
		e.printStackTrace();
	}finally {
		closeDB(conn,ptmt,rs);
	}		
	
	return seekUserResult;	
}

public static boolean loginValidate(String userName,String passWord) {
	boolean loginSuccess=false;
	Connection conn=getConnection();
	
	String user_Login_Sql="select * from user where username=? and password=?";
	PreparedStatement ptmt=null;
	ResultSet rs=null;
	try {
		ptmt=conn.prepareStatement(user_Login_Sql);
		ptmt.setString(1, userName);
		ptmt.setString(2, passWord);
		
		
		rs=ptmt.executeQuery();
		
		loginSuccess=rs.next();
	} catch (SQLException e) {
		e.printStackTrace();
	}finally {
		closeDB(conn,ptmt,rs);
	}		
	System.out.println("loginSuccess为："+loginSuccess);
	return loginSuccess;
}

public static String getFriendString(String userName) {
	Connection conn=getConnection();
	String friend_Relation_Sql="select slaveuser from relation where majoruser=? and relationtype='1'";
	PreparedStatement ptmt=null;
	String friendString="";
	ResultSet rs=null;
	try {
		ptmt=conn.prepareStatement(friend_Relation_Sql);
		ptmt.setString(1, userName);
		rs=ptmt.executeQuery();
		
		while(rs.next()) {
			friendString=friendString+rs.getString("slaveuser")+" ";
		}
	} catch (SQLException e) {
		e.printStackTrace();
	}finally {
		closeDB(conn,ptmt,rs);
	}
	return friendString;
}

public static void closeDB(Connection conn,PreparedStatement ptmt) {
	if(conn!=null) {
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	if(ptmt!=null) {
		try {
			ptmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

public static void closeDB(Connection conn,PreparedStatement ptmt,ResultSet rs) {
	if(conn!=null) {
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	if(ptmt!=null) {
		try {
			ptmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	if(rs!=null) {
		try {
			rs.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
}

}