新建 文本文档.txt

Personal financial management system

  String info=null;
  boolean model=true;
  String ID=((String)tabel.getValueAt(0,0)).trim();
  String spend=((String)tabel.getValueAt(0,1)).trim();
  String epecificSpending=(String)tabel.getValueAt(0, 2);
  String come=((String)tabel.getValueAt(0, 3)).trim();
  String epecificIncome=(String)tabel.getValueAt(0, 4);
  String journal=(String)tabel.getValueAt(0, 6);
  try{
   int id=Integer.parseInt(ID);
   float spending=Float.parseFloat(spend);
   float income=Float.parseFloat(come);
   tabel.setValueAt(""+(income-spending), 0, 4);
   SysBean sysbean=new SysBean();
   sysbean.setName(use);
   sysbean.setID(id);
   sysbean.setSpending(spending);
   sysbean.setEpecificSpending(epecificSpending);
   sysbean.setIncome(income);
   sysbean.setEpecificIncome(epecificIncome);
   sysbean.setJournal(journal);
   model=new Operate().update(sysbean);
   if(model){
    info="更新成功!";
    tabel.setValueAt("", 0,0);
    tabel.setValueAt("", 0,1);
    tabel.setValueAt("", 0,2);
    tabel.setValueAt("", 0,3);
    tabel.setValueAt("", 0,4);
    tabel.setValueAt("", 0,5);
    tabel.setValueAt("", 0,6);
    
   }else{
    info="更新失败!";
   }
  }catch(Exception o){
   info="请正确输入数据!";
  }

  JOptionPane.showMessageDialog(this, info);
 }
 public void addSource(){
  String info=null;
  boolean model=true;
  String spend=((String)tabel.getValueAt(0,1)).trim();
  String epecificSpending=(String)tabel.getValueAt(0, 2);
  String come=((String)tabel.getValueAt(0, 3)).trim();
  String epecificIncome=(String)tabel.getValueAt(0, 4);
  String journal=(String)tabel.getValueAt(0, 6);
  try{
   float spending=Float.parseFloat(spend);
   float income=Float.parseFloat(come);
   tabel.setValueAt(""+(income-spending), 0, 4);
   SysBean sysbean=new SysBean();
   sysbean.setName(use);
   sysbean.setSpending(spending);
   sysbean.setEpecificSpending(epecificSpending);
   sysbean.setIncome(income);
   sysbean.setEpecificIncome(epecificIncome);
   sysbean.setJournal(journal);
   model=new Operate().add(sysbean);
   if(model){
    info="添加成功!";
    tabel.setValueAt("", 0,0);
    tabel.setValueAt("", 0,1);
    tabel.setValueAt("", 0,2);
    tabel.setValueAt("", 0,3);
    tabel.setValueAt("", 0,4);
    tabel.setValueAt("", 0,5);
    tabel.setValueAt("", 0,6);
    
   }else{
    info="添加失败!";
   }
  }catch(Exception o){
   info="请正确输入数据!";
  }
  JOptionPane.showMessageDialog(this, info);
 }
}
操作类：
import java.sql.*;
import java.util.*;
import javawork.bean.*;
public class Operate {
 Connection conn=null;
 PreparedStatement pstmt=null;
 ResultSet rs=null;
 String sql=null;
 public Vector<SysBean> selectDay(String name,java.sql.Date beginDate,java.sql.Date endDate){
  Vector<SysBean> vector=new Vector<SysBean>();
  System.out.println("selectDay"+" "+beginDate+" "+endDate);
  init();
  sql="select * from info where name=? and date between ? and ?";
  pstmt=DataBaseConnection.getpStmt(conn, sql);
  try {
   pstmt.setString(1, name);
   pstmt.setDate(2, beginDate);
   pstmt.setDate(3, endDate);
   rs=pstmt.executeQuery();
   while(rs.next()){
    SysBean sysbean=new SysBean();
    sysbean.setID(rs.getInt("ID"));
    sysbean.setName(rs.getString("name"));
    sysbean.setSpending(rs.getFloat("spending"));
    sysbean.setEpecificSpending(rs.getString("epecificSpending"));
    sysbean.setIncome(rs.getFloat("income"));
    sysbean.setEpecificIncome(rs.getString("epecificIncome"));
    sysbean.setTotal(rs.getFloat("total"));
    sysbean.setJournal(rs.getString("journal"));
    sysbean.setDate(rs.getDate("date"));
    sysbean.setID(rs.getInt("ID"));
    System.out.println("sysbean.getname= "+sysbean.getDate());
    vector.add(sysbean);
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
  close();
  return vector;
 }
 public void init(){
  conn=DataBaseConnection.getConn();
 }
 public void close(){
  if(rs!=null){
   DataBaseConnection.closeRs(rs);
  }
  DataBaseConnection.closePstmt(pstmt);
  DataBaseConnection.closeConn(conn);
 }
 public boolean login(String user,String password){
  init();
  boolean login=false;
  sql="select * from ruse where name=? and password=?";
  pstmt=DataBaseConnection.getpStmt(conn, sql);
  try {
   pstmt.setString(1, user);
   pstmt.setString(2, password);
   rs=pstmt.executeQuery();
   if(rs.next()){
    login=true;
   }  
  } catch (SQLException e) {
   e.printStackTrace();
  }
  close();
  return login;
 }
 public Vector<SysBean> select(String user){
  Vector<SysBean> vector=new Vector<SysBean>();
  init();
  sql="select * from info where name=?";
  pstmt=DataBaseConnection.getpStmt(conn, sql);
  try {
   pstmt.setString(1, user);
   rs=pstmt.executeQuery();
   while(rs.next()){
    SysBean sysbean=new SysBean();
    sysbean.setID(rs.getInt("ID"));
    sysbean.setName(rs.getString("name"));
    sysbean.setSpending(rs.getFloat("spending"));
    sysbean.setEpecificSpending(rs.getString("epecificSpending"));
    sysbean.setIncome(rs.getFloat("income"));
    sysbean.setEpecificIncome(rs.getString("epecificIncome"));
    sysbean.setTotal(rs.getFloat("total"));
    sysbean.setJournal(rs.getString("journal"));
    sysbean.setDate(rs.getDate("date"));
    sysbean.setID(rs.getInt("ID"));
    vector.add(sysbean);
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
  close();
  return vector;
 }
 public boolean add(SysBean sysbean){
  boolean model=true;
  init();
  sql="insert into info(name,spending,epecificSpending,income," +
    "epecificIncome,journal,date) values(?,?,?,?,?,?,?)";
  pstmt=DataBaseConnection.getpStmt(conn, sql);
  try {
   pstmt.setString(1, sysbean.getName());
   pstmt.setFloat(2, sysbean.getSpending());
   pstmt.setString(3, sysbean.getEpecificSpending());
   pstmt.setFloat(4, sysbean.getIncome());
   pstmt.setString(5, sysbean.getEpecificIncome());
   pstmt.setString(6, sysbean.getJournal());
   pstmt.setDate(7, new java.sql.Date(new java.util.Date().getTime()));
   pstmt.executeUpdate();
  } catch (SQLException e) {
   e.printStackTrace();
   model=false;
  }
  close();
  return model;  
 }
 public boolean delete(int ID,String use){
  boolean model=true;
  sql="delete from info where ID=? and name=?";
  init();
  pstmt=DataBaseConnection.getpStmt(conn, sql);
  try {
   pstmt.setInt(1, ID);
   pstmt.setString(2, use);
   pstmt.executeUpdate();
  } catch (SQLException e) {
   e.printStackTrace();
   model=false;
  }
  close();
  return model;
 }
 public boolean update(SysBean sysbean){
  boolean model=true;
  sql="update info set spending=?," +
    "epecificSpending=?,income=?,epecificIncome=?,journal=? where ID=? and name=?";
  init();
  pstmt=DataBaseConnection.getpStmt(conn, sql);
  try{
   pstmt.setFloat(1, sysbean.getSpending());
   pstmt.setString(2, sysbean.getEpecificSpending());
   pstmt.setFloat(3, sysbean.getIncome());
   pstmt.setString(4, sysbean.getEpecificIncome());
   pstmt.setString(5, sysbean.getJournal());
   pstmt.setInt(6, sysbean.getID());
   pstmt.setString(7, sysbean.getName());
   pstmt.executeUpdate();
  }catch(Exception e){
   model=false;
  }
  return model;
 }
 public boolean register(String wm,String password){
  boolean model=true;
  sql="insert into ruse values(?,?)";
  init();
  pstmt=DataBaseConnection.getpStmt(conn, sql);
  try{
   pstmt.setString(1,wm);
   pstmt.setString(2,password);
   pstmt.executeUpdate();
  }catch(SQLException e){
   model=false;
  }
  return model;
 }
}
//数据库连接类：
import java.sql.*;
public class DataBaseConnection {
 static{
  //2005
  //String DBDRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";//2000
 }
 public static Connection getConn(){
  String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
  String DBURL="jdbc:sqlserver://localhost:1433;DatabaseName=cwgl";
  Connection conn=null;
  try {
   Class.forName(DBDRIVER);
   conn=DriverManager.getConnection(DBURL,"sa","1");
  } catch (Exception e) {
   e.printStackTrace();
  }
  return conn;
 }
 public static void closeConn(Connection conn){
  try {
   conn.close();
   conn=null;
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }
 public static Statement getStmt(Connection conn){
  Statement stmt=null;
  try {
   stmt=conn.createStatement();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return stmt;
 }
 public static void closeStmt(Statement stmt){
  try {
   stmt.close();
   stmt=null;
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }
 public static PreparedStatement getpStmt(Connection conn,String sql){
  PreparedStatement pStmt=null;
  try {
   pStmt=conn.prepareStatement(sql);
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return pStmt;
 }
 public static void closePstmt(Statement pstmt){
  try {
   pstmt.close();
   pstmt=null;
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }
 public static ResultSet getRs(Statement stmt,String sql){
  ResultSet rs=null;
  try {
   rs=stmt.executeQuery(sql);
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return rs;
 }
 public static void closeRs(ResultSet rs){
  try {
   rs.close();
   rs=null;
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }
}