?? regbean.java
字號(hào):
package shop;
import java.sql.*;
public class regBean {
String id="";
String name="";
String pwd="";
String sex="";
String mail="";
String addr="";
String call="";
String intr="";
String success="false";
Connection con;
Statement sql;
ResultSet rs;
public regBean() {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
}
public void setId(String s){id=s;}
public void setName(String s){name=s;}
public void setPwd(String s){pwd=s;}
public void setSex(String s){sex=s;}
public void setMail(String s){mail=s;}
public void setAddr(String s){addr=s;}
public void setCall(String s){call=s;}
public void setIntr(String s){intr=s;}
public String getId(){return id;}
public String getName(){return name;}
public String getPwd(){return pwd;}
public String getSex(){return sex;}
public String getMail(){return mail;}
public String getAddr(){return addr;}
public String getCall(){return call;}
public String getIntr(){return intr;}
public String getSuccess(){
if(id.equals("")){
success="false";
return success;
}
try{
con=DriverManager.getConnection("jdbc:odbc:myshop","","");
sql = con.createStatement();
String condition="select * from user where id="+"'"+id+"'";
rs=sql.executeQuery(condition);
if(rs.next()){
success="false";
con.close();
return success;
}
else{
String insert="insert into user values (?,?,?,?,?,?,?,?);";
PreparedStatement pstmt=con.prepareStatement(insert);
pstmt.setString(1,id);
pstmt.setString(2,name);
pstmt.setString(3,pwd);
pstmt.setString(4,sex);
pstmt.setString(5,mail);
pstmt.setString(6,addr);
pstmt.setString(7,call);
pstmt.setString(8,intr);
pstmt.executeUpdate();
pstmt.close();
success="true";
con.close();
return success;
}
}catch(SQLException e){
success="false";
return success;
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -