Java中date与Jsp中date交互
文章作者 100test 发表时间 2011:03:17 21:07:10
来源 100Test.Com百考试题网
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.
#ff0000>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 = "0select 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.
#ff0000>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.
}