Judge.java:
package com.goodhope.regist;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
public class Judge {
Statement stmt;
ResultSet rs;
public void init() {
try {
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/postgres";
Connection con = DriverManager.getConnection(url, "postgres",
"pair36");
stmt = con.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
}
public boolean IfExit(String username) {
Boolean a = false;
init();
String sql = "select name from cas where name='" + username + "'";
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
try {
a = rs.next();
} catch (SQLException e) {
e.printStackTrace();
}
return a;
}
public void InsetIntoTable(String name, String pwd, Date birthday) {
init();
String sql = "insert into cas (name,password,birthday) values ('"
+ name + "','" + pwd + "',to_date('" + birthday
+ "','yyyy-mm-dd'))";
try {
stmt.execute(sql);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Regist.java
package com.goodhope.regist;
import java.sql.Date;
import com.opensymphony.xwork2.ActionSupport;
public class Regist extends ActionSupport {
private static final long serialVersionUID = -5254042367980236169L;
private String username;
private String password;
private Date birthday;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
① 凡本网注明稿件来源为"原创"的所有文字、图片和音视频稿件,版权均属本网所有。任何媒体、网站或个人转载、链接转贴或以其他方式复制发表时必须注明"稿件来源:我考网",违者本网将依法追究责任;
② 本网部分稿件来源于网络,任何单位或个人认为我考网发布的内容可能涉嫌侵犯其合法权益,应该及时向我考网书面反馈,并提供身份证明、权属证明及详细侵权情况证明,我考网在收到上述法律文件后,将会尽快移除被控侵权内容。