userregist.java

用JSP实现的一个网上书店的程序

package com;

import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;

public class UserRegist
{
	private UserInfo userInfo;
	private Connection con;
	
	//获得数据库连接。
	public UserRegist()
	{
	 	String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	    String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shop";
	    String USER="sa";
	    String PWD="sa";
	    try
	    {
	    	
	    	Class.forName(CLASSFORNAME);
			con = DriverManager.getConnection(SERVANDDB,USER,PWD);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	//设置待注册的用户信息。
	public void setUserInfo(UserInfo userInfo)
	{
		this.userInfo=userInfo;
	}
	
	//进行注册
	public void regist()throws Exception
	{
		String reg="insert into UserTable values(?,?,?,?)";
		
		try
		{
			PreparedStatement pstmt=con.prepareStatement(reg);
			pstmt.setString(1,userInfo.getUsername());
			pstmt.setString(2,userInfo.getPassword());
			pstmt.setString(3,"user");
			pstmt.setString(4,userInfo.getOther());
			pstmt.executeUpdate();
		}
		catch(Exception e)
		{
			e.printStackTrace();
			throw e;
		}
	}
}