userservice.java

来自「Ajax 简单应用」· Java 代码 · 共 46 行

package service;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Map;

import DB.DBUtils;

public class UserService {
	public boolean isUserExists(String username){
		boolean say = false;
		DBUtils dBUtils= new DBUtils();
		Connection con=dBUtils.getConnection();
		try {
			Statement sta= con.createStatement();
			ResultSet res=sta.executeQuery("select * from t_userinfo where username='"+username+"'");
			if(!res.next()){
				say=false;
			}else{
				say=true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return say;
	}
	public boolean register(String username,int sex,String level,String remark){
		System.out.println("^^^^^^^^^^^");
		boolean call = false;
		DBUtils dBUtils= new DBUtils();
		Connection con=dBUtils.getConnection();
		try {
			Statement sta= con.createStatement();
			sta.executeUpdate("insert into t_userinfo(username,Sex,level,remark)values('"+username+"','"+sex+"','"+level+"','"+remark+"')");
			call=true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return call;
	}
}