说明:
1.User类、SaveUser类
2.oracle数据库
3.生日用java.sql.Date类型。以前用java.util.Date类型一直存在类型问题出现bug
一下为源代码:
一.SaveUser类
package com.bluedot.domain;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.sql.Date;
public class SaveUser {
public static void saveUser(User user) {
String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
String USER = "system";
String PWD = "system";
Connection conn = null;
PreparedStatement pstm = null;
String sql = "insert into registers(USER_NAME,PASSWORD,FULL_NAME,EMAIL,MALE,BIRTHDAY) values(?,?,?,?,?,?)";
int index = 0;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(URL,USER,PWD);
pstm = conn.prepareStatement(sql);
pstm.setString(1, user.getUserName());
pstm.setString(2, user.getPassword());
pstm.setString(3, user.getFullName());
pstm.setString(4, user.getEmail());
pstm.setInt(5, user.isMale() ? 1 : 0);
pstm.setDate(6,user.getBirthday());
pstm.execute();
pstm.close();
} catch(SQLException ex) {
throw new RuntimeException();
} finally{
if(conn != null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public static void main(String args[]) {
User user = new User();
user.setUserName("test222");
user.setPassword("pwdtest");
user.setFullName("zhangsan");
user.setEmail("testemail");
user.setMale(true);
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
try {
Date birthday = new Date(dateFormat.parse("1990-01-11").getTime());
user.setBirthday(birthday);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
SaveUser.saveUser(user);
}
}
二.User类
package com.bluedot.domain;
import java.io.Serializable;
import java.sql.Date;
public class User {
private static final long serialVersionUID = 1L;
private String userName;
private String password;
private String fullName;
private boolean male;
private String email;
private Date birthday;
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = 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 String getFullName() {
return fullName;
}
public void setFullName(String fullName) {
this.fullName = fullName;
}
public boolean isMale() {
return male;
}
public void setMale(boolean male) {
this.male = male;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
}