package student;
/**
 * @author zxy
 *
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
//import java.text.SimpleDateFormat;

public class StudentBean {
	private String xh;
	private String xm;
	private String xb;
	private int nl;
	private String zzmm;
	private String bz;
	
	public StudentBean(String xh,String xm,String xb,String zzmm,String bz,int nl){
		this.xh=xh;
		this.xm=xm;
		this.xb=xb;
		this.zzmm=zzmm;
		this.nl=nl;
		this.bz=bz;
	}
	/**
	 * @return Returns the bz.
	 */
	public String getBz() {
		return bz;
	}
	/**
	 * @return Returns the csrq.
	 */
	public int getNl() {
		return nl;
	}
	/**
	 * @return Returns the xb.
	 */
	public String getXb() {
		return xb;
	}
	/**
	 * @return Returns the xh.
	 */
	public String getXh() {
		return xh;
	}
	/**
	 * @return Returns the xm.
	 */
	public String getXm() {
		return xm;
	}
	/**
	 * @return Returns the zzmm.
	 */
	public String getZzmm() {
		return zzmm;
	}
    public void insert() throws Exception{
    	String drivername = "org.gjt.mm.mysql.Driver";
    	String connName="jdbc:mysql://localhost:3306/student?user=root&password=root";
        Class.forName(drivername).newInstance();
        Connection conn=DriverManager.getConnection(connName);
        PreparedStatement state=null;
        try{
        	state=conn.prepareStatement("INSERT INTO studinfo(xh,xm,xb,zzmm,bz,nl)"+" values(?,?,?,?,?,?)");
            conn.setAutoCommit(false);
            state.setString(1,xh);
            state.setString(2,xm);
            state.setString(3,xb);
            state.setString(4,zzmm);
            state.setString(5,bz);
            state.setInt(6,nl);
            state.executeUpdate();
            conn.commit();
            System.out.print("榪滅▼鏂囦歡淇