|
|
第一个connDB.java
package xiuxianblog.connects;
import java.sql.*;
public class connDB
{
//处于安全考虑，数据库连接，用户名和密码设为私有类型，禁止其他类查看
private static Connection con=null;
private static String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Blog_DB";
private static String user="sa";
private static String pwd="sa";
public static Connection getConnection()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con=DriverManager.getConnection(url,user,pwd);
}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
}
第2个UserReg.java
package xiuxianblog.connects;
import java.sql.*;
import xiuxianblog.connects.connDB;
public class UserReg {
connDB conndb=new connDB();
Connection con=null;
Statement stmt;
ResultSet rt;
String username;
String blogname;
String petname;
String pwd;
String pwdclew;
String pwdkey;
String email;
String age;
String sex;
String province;
String city;
//setter 方法
public void setusername(String newusername){
username=newusername;
}
public void setblogname(String newblogname){
blogname=newblogname;
}
public void setpetname(String newpetname){
petname=newpetname;
}
public void setpwd(String newpwd){
pwd=newpwd;
}
public void setpwdclew(String newpwdclew){
pwdclew=newpwdclew;
}
public void setpwdkey(String newpwdkey){
pwdkey=newpwdkey;
}
public void setemail(String newemail){
email=newemail;
}
public void setage(String newage){
age=newage;
}
public void setprovince(String newprovince){
province=newprovince;
}
public void setsex(String newsex){
sex=newsex;
}
public void setcity(String newcity){
city=province+newcity;
}
//getter方法
public String getusername(){
return username;
}
public String getblogname(){
return blogname;
}
public String getpetname(){
return petname;
}
public String getpwd(){
return pwd;
}
public String getpwdclew(){
return pwdclew;
}
public String getpwdkey(){
return pwdkey;
}
public String getemail(){
return email;
}
public String getage(){
return age;
}
public String getsex(){
return sex;
}
public void selectDate(String Username){
ResultSet rs;
try{
rs=stmt.executeQuery("select * from Blog_User where UserName='"+username+"'");
rs.next();
username=rs.getString("username");
blogname=rs.getString("blogname");
petname=rs.getString("petname");
pwdclew=rs.getString("pwdclew");
pwdkey=rs.getString("pwdkey");
email=rs.getString("email");
age=rs.getString("age");
}
catch(Exception em){
em.printStackTrace();
}
}
public String ValiDate(){//如果返回值为right，则注册成功，如果为username，则表示帐号重复
String t="null";
ResultSet rs;
try{
rs=stmt.executeQuery("select username from Blog_User");
while(rs.next()){
String name=rs.getString("username");
if(name.equals(username)){
t="username";//username重复了
break;
}
else{
t="right";
}
}
if(t.equals("right")){//t=right,即注册成功
InsertDate();
}
if(t.equals("null")){//t=null,即数据库第一次有数据输入
InsertDate();
}
con.close();
stmt.close();
}
catch(Exception em){
em.printStackTrace();
}
return t;
}
public void InsertDate(){
try{
stmt.executeUpdate("insert into Blog_User(username,Blog_Name,User_Petname,User_Pwd,User_Pwdclew,User_Pwdkey,User_Email,User_Age,User_Sex,User_City)values('"+username+"','"+blogname+"','"+petname+"','"+pwd+"','"+pwdclew+"','"+pwdkey+"','"+email+"','"+age+"','"+sex+"','"+city+"')");
}
catch(Exception e){
e.printStackTrace();
}
}
}
提交的JSP页面
<%@page contentType="text/html;charset=gb2312" import="xiuxianblog.connects.*"%>
<jsp:useBean id="rs" class="xiuxianblog.connects.UserReg"/>
<html>
<body>
<%! String vd; %>
<%
rs.setusername(request.getParameter("username"));
rs.setblogname(request.getParameter("blogname"));
rs.setpetname(request.getParameter("petname"));
rs.setpwd(request.getParameter("pwd"));
rs.setpwdclew(request.getParameter("pwdclew"));
rs.setpwdkey(request.getParameter("pwdkey"));
rs.setemail(request.getParameter("email"));
rs.setage(request.getParameter("age"));
rs.setsex(request.getParameter("sex"));
rs.setprovince(request.getParameter("province"));
rs.setcity(request.getParameter("city"));
vd=rt.ValiDate();
if(vd.equals("right")){
%>
<script language="javascript">
<!--
alert("恭喜你注册成功");
location='index.jsp';
-->
</script>
<%
}
if(vd.equals("null")){
%>
<script language="javascript">
<!--
out.print(username);
alert("恭喜你注册成功");
location='index.jsp';
-->
</script>
<%
}
if(vd.equals("username")){
%>
<script language="javascript">
<!--
alert("用户已存在");
location='register.jsp';
-->
</script>
<%
}
%>
</body>
</html> |
|
发表于 2020-1-6 10:00:01