用户名: 
    
    

      密码: 
    
    

      再次输入密码: 
    
    

       
    
  

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="javaBean.userbean;"%>


  
  
  用户名： 
  


  密码： 
  


  <%  out.println(user.insert());  %>

package javaBean;
import java.sql.*;
public class userbean{
	private String username;
	private String password;
	public void setUsername(String username) {
		this.username=username;
	}
	public void setPassword(String password) {
		this.password=password;
	}
	public String getUsername() {
		return username;
	}
	public String getPassword() {
		return password;
	}
	public String insert(){
		try{
			String url ="jdbc:mysql://localhost:3306/mysql";
			//数据库连接字符串 
			Class.forName("org.gjt.mm.mysql.Driver").newInstance();
			//加载驱动程序
			Connection conn= DriverManager.getConnection(url,"root","dba");
			//建立连接
			String sql="select * from login_user where username=?";
			PreparedStatement pStmt = conn.prepareStatement(sql);
			pStmt.setString(1,username);
			ResultSet rs=pStmt.executeQuery();
			if(rs.next())
			      {
				return "该用户名已存在！";
			} else
			      {
				sql="insert into login_user values(?,?)";
				pStmt = conn.prepareStatement(sql);
				pStmt.setString(1,username);
				pStmt.setString(2,password);
				pStmt.executeUpdate();
				return "注册成功！";
			}
		}
		catch(Exception e){
			return "注册失败！";
		}
	}
}