register.java

我的系统

package aa;
import java.io.*;
import java.sql.*;
public class Register {
	private String sAccountID="";
	private String sPin="";
	private String Birthday="";
	private String Address="";
	private String Telephone="";
	
	Connection con = null;
	PreparedStatement st = null;
	ResultSet result = null;
	public void setsAccountID(String sAccountID) {
		this.sAccountID = sAccountID;
	}
	public void setsPin(String sPin) {
		this.sPin = sPin;
	
	}
	public String getsAccountID() {
		return this.sAccountID;
	}
	public String getsPin() {
		return sPin;
	}
	public String getBirthday() {
		return Birthday;
	}
	public String getAddress() {
		return Address;
	}
	public String getTelephone() {
		return Telephone;
	}
	public void setBirthday(String Birthday) {
		this.Birthday = Birthday;
	}
	public void setAddress(String Address) {
		this.Address = Address;
	}
	public void setTelephone(String Telephone) {
		this.Telephone = Telephone;
	}
	
	public Register()  {
		
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
	}
	public void Register1() {
			sAccountID = getsAccountID();
			sPin = getsPin();
			Birthday = getBirthday();
			Address = getAddress();
			Telephone = getTelephone();
			try {
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test","sa","");
			} catch(SQLException e) {
				e.printStackTrace();
			}
			String strQuery = "insert into Info values (?,?,?,?,?)";
			try {
			st = con.prepareStatement(strQuery);
			st.setString(1, sAccountID);
			st.setString(2, sPin);
			st.setString(3, Birthday);
			st.setString(4, Address);
			st.setString(5, Telephone);
			st.executeUpdate();
			} catch (SQLException e ) {
				e.printStackTrace();
			}
			
		
}
	public static void main(String [] args) {
		Register reg = new Register();
		reg.Register1();
	}
}