adduser.java

通过jsp,servlet,javaBean,三成架构实现的好友通讯录系统

package com.Dao;

import java.sql.*;
import com.db.DBManager;

public class AddUser
{
    public Connection conn;
    public PreparedStatement ps;
    public ResultSet rs;

    public AddUser()
    {
        conn=DBManager.getConnetion();
    }
    public int AddUsers(String username,String password,String realname,String sex)
    {
        int result=0;
        String sql="insert USERS(userName,password,realName,sex) values(?,?,?,?)";
        try{
             ps=conn.prepareStatement(sql);
             ps.setString(1,username);
             ps.setString(2,password);
             ps.setString(3,realname);
             ps.setString(4,sex);
             result=ps.executeUpdate();
        }catch(Exception e){
            System.out.println("插入数据失败！");
            e.printStackTrace();
        }
        return result;
    }
}