/* 创建日期 2005-4-14 */
package gbook;import java.sql.*;
import java.util.Date;
import java.text.SimpleDateFormat;public class DBAction {
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
Statement stmt = null;
public boolean InsertUser(String Username,String Password,int Age,String Sex,String Message,String Web,String RegIP,int Grade) throws Exception
{
SimpleDateFormat slf = new SimpleDateFormat();
Date dt = new Date();
String RegDate =new String(slf.format(dt).getBytes("iso-8859-1"));
boolean isInsert = false;
DbLink db = new DbLink();
try{
con = db.getConn();
con.setAutoCommit(true);
//stmt = con.createStatement();
//stmt.executeUpdate(sql);
String sql = "insert into UserTable(Username,Password,Age,Sex,Web,Message,RegIP,Grade) values (?,?,?,?,?,?,?,?)";
ps = con.prepareStatement(sql);
ps.setString(1,Username);
ps.setString(2,Password);
ps.setInt(3,Age);
ps.setString(4,Sex);
ps.setString(5,Web);
ps.setString(6,Message);
ps.setString(7,RegIP);
ps.setInt(8,Grade);
if(ps.executeUpdate() != 1)
{
System.out.println("InsertUser error!");
}
}catch(SQLException e)
{
System.out.println(e.getMessage() +"InsertDate error");
}
return isInsert;
}
}
package gbook;import java.sql.*;
import java.util.Date;
import java.text.SimpleDateFormat;public class DBAction {
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
Statement stmt = null;
public boolean InsertUser(String Username,String Password,int Age,String Sex,String Message,String Web,String RegIP,int Grade) throws Exception
{
SimpleDateFormat slf = new SimpleDateFormat();
Date dt = new Date();
String RegDate =new String(slf.format(dt).getBytes("iso-8859-1"));
boolean isInsert = false;
DbLink db = new DbLink();
try{
con = db.getConn();
con.setAutoCommit(true);
//stmt = con.createStatement();
//stmt.executeUpdate(sql);
String sql = "insert into UserTable(Username,Password,Age,Sex,Web,Message,RegIP,Grade) values (?,?,?,?,?,?,?,?)";
ps = con.prepareStatement(sql);
ps.setString(1,Username);
ps.setString(2,Password);
ps.setInt(3,Age);
ps.setString(4,Sex);
ps.setString(5,Web);
ps.setString(6,Message);
ps.setString(7,RegIP);
ps.setInt(8,Grade);
if(ps.executeUpdate() != 1)
{
System.out.println("InsertUser error!");
}
}catch(SQLException e)
{
System.out.println(e.getMessage() +"InsertDate error");
}
return isInsert;
}
}
package gbook;
import java.sql.*;public class DBCon {
Connection con;
String drv = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:gbook";
public Connection getConnection() throws SQLException{
try{
Class.forName(drv);
con = DriverManager.getConnection(url,"","");
}catch(ClassNotFoundException e){
System.out.print(e.getMessage()+"ClassNotFound");
}
return con;
}
}
package gbook;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBexecute {
Connection con = null;
ResultSet rs = null;
Statement stmt = null;
DBCon db = new DBCon();
public void executeUpdate(String sql){
try{
con = db.getConnection();
stmt = con.createStatement();
stmt.executeUpdate(sql);
}catch(SQLException e){
System.out.println(e.getMessage()+"update sql error");
}
}
public ResultSet executeQuery(String sql){
try{
con = db.getConnection();
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}catch(SQLException e){
System.out.println(e.getMessage()+"rs error");
}
return rs;
}
public boolean IsUserLogin(String username,String password){
boolean IsLogin = true;
try{
String sql = "select * from diaryuser where username = '"+ username +"' and password = '"+ password +"'";
con = db.getConnection();
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
if(!rs.next())
IsLogin = false;
}catch(SQLException e){
System.out.println(e.getMessage()+"IsLogin error");
}
return IsLogin;
}
public void CloseDB() throws SQLException{
if(rs != null)
rs.close();
if(stmt != null)
stmt.close();
if(con != null)
con.close();
}
}