?? studentbean.java
字號:
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("榪滅▼鏂囦歡淇
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -