regform.java

实现图书管理

package mypkg;

import java.io.UnsupportedEncodingException;
import java.security.NoSuchAlgorithmException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class RegForm {
	private String username;
	private String passwd1;
	private String passwd2;
	private String email;
	private String zipcode;
	private String address;
	private String telephone;

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getPasswd1() {
		return passwd1;
	}

	public void setPasswd1(String passwd1) {
		this.passwd1 = passwd1;
	}

	public String getPasswd2() {
		return passwd2;
	}

	public void setPasswd2(String passwd2) {
		this.passwd2 = passwd2;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getZipcode() {
		return zipcode;
	}

	public void setZipcode(String zipcode) {
		this.zipcode = zipcode;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getTelephone() {
		return telephone;
	}

	public void setTelephone(String telephone) {
		this.telephone = telephone;
	}

	public int register() throws SQLException, ClassNotFoundException, UnsupportedEncodingException, NoSuchAlgorithmException {
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection conn = null;
		try {
			conn = DriverManager.getConnection("jdbc:odbc:database");
			String sql = "insert into users(username,passwd1,zipcode,"
					+ "address,telephone,email) values(?,?,?,?,?,?)";
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			pstmt.setString(2, MD5.md5(passwd1));
			pstmt.setString(3, zipcode);
			pstmt.setString(4, address);
			pstmt.setString(5, telephone);
			pstmt.setString(6, email);
			int n = pstmt.executeUpdate();
			return n;
		} finally {
			if (conn != null)
				conn.close();
		}
	}
}