求助！跪求！这个在myeclipse中实现不了~~求帮忙解决一下！~~万分感谢！

[baihua271314]

MainFram.java



package Family;

import java.util.*;
import Family.DAO;


public class MainFram extends javax.swing.JFrame {


public MainFram() {
initComponents();
this.setSize(385, 550);
this.setResizable(false);
this.setDefaultCloseOperation(1);
this.setLocationRelativeTo(this);
this.setVisible(true);
}


//GEN-BEGIN:initComponents
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {

buttonGroup1 = new javax.swing.ButtonGroup();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
radOut = new javax.swing.JRadioButton();
radIn = new javax.swing.JRadioButton();
jLabel3 = new javax.swing.JLabel();
cboItem = new javax.swing.JComboBox();
jLabel4 = new javax.swing.JLabel();
txtMoney = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
txtName = new javax.swing.JTextField();
btnAdd = new javax.swing.JButton();
btnRemake = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
txaInner = new javax.swing.JTextArea();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
getContentPane().setLayout(null);

jLabel1.setFont(new java.awt.Font("宋体", 1, 24));
jLabel1.setText("\u4e2a\u4eba\u8d22\u52a1\u7ba1\u7406\u7cfb\u7edf");
getContentPane().add(jLabel1);
jLabel1.setBounds(80, 20, 210, 50);

jLabel2.setFont(new java.awt.Font("宋体", 1, 18));
jLabel2.setText("\u6536\u5165\\\u652f\u51fa\uff1a");
getContentPane().add(jLabel2);
jLabel2.setBounds(40, 80, 110, 40);

buttonGroup1.add(radOut);
radOut.setFont(new java.awt.Font("宋体", 0, 18));
radOut.setSelected(true);
radOut.setText("\u652f\u51fa");
radOut.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
radOutActionPerformed(evt);
}
});
getContentPane().add(radOut);
radOut.setBounds(180, 90, 61, 30);

buttonGroup1.add(radIn);
radIn.setFont(new java.awt.Font("宋体", 0, 18));
radIn.setText("\u6536\u5165");
radIn.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
radInActionPerformed(evt);
}
});
getContentPane().add(radIn);
radIn.setBounds(260, 90, 70, 30);

jLabel3.setFont(new java.awt.Font("宋体", 1, 18));
jLabel3.setText("\u6536\u652f\u9879\u76ee\uff1a");
getContentPane().add(jLabel3);
jLabel3.setBounds(50, 140, 100, 30);

cboItem.setFont(new java.awt.Font("宋体", 0, 18));
cboItem.setModel(new javax.swing.DefaultComboBoxModel(new String[] {
"伙食费", "学费", "手机费", "上网费" }));
cboItem.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cboItemActionPerformed(evt);
}
});
getContentPane().add(cboItem);
cboItem.setBounds(180, 140, 140, 30);

jLabel4.setFont(new java.awt.Font("宋体", 1, 18));
jLabel4.setText("\u91d1\u989d\uff1a");
getContentPane().add(jLabel4);
jLabel4.setBounds(90, 190, 57, 30);

txtMoney.setFont(new java.awt.Font("宋体", 1, 18));
getContentPane().add(txtMoney);
txtMoney.setBounds(180, 190, 70, 30);

jLabel5.setFont(new java.awt.Font("宋体", 1, 18));
jLabel5.setText("\u6536\u652f\u4eba\uff1a");
getContentPane().add(jLabel5);
jLabel5.setBounds(70, 240, 80, 30);

txtName.setFont(new java.awt.Font("宋体", 0, 18));
txtName.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtNameActionPerformed(evt);
}
});
getContentPane().add(txtName);
txtName.setBounds(180, 240, 70, 30);

btnAdd.setFont(new java.awt.Font("宋体", 1, 18));
btnAdd.setText("\u6dfb\u52a0");
btnAdd.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnAddActionPerformed(evt);
}
});
getContentPane().add(btnAdd);
btnAdd.setBounds(70, 310, 73, 40);

btnRemake.setFont(new java.awt.Font("宋体", 1, 18));
btnRemake.setText("\u91cd\u7f6e");
btnRemake.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnRemakeActionPerformed(evt);
}
});
getContentPane().add(btnRemake);
btnRemake.setBounds(230, 310, 73, 40);

txaInner.setColumns(20);
txaInner.setFont(new java.awt.Font("Courier", 1, 14));
txaInner.setRows(100);
jScrollPane1.setViewportView(txaInner);

getContentPane().add(jScrollPane1);
jScrollPane1.setBounds(30, 380, 320, 130);

pack();
}

private void btnRemakeActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:重置按钮
radOut.setSelected(true);
cboItem.setSelectedIndex(0);
txtMoney.setText("");
txtName.setText("");
}

private void btnAddActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:添加按钮
try {
String income = null;
if (radOut.isSelected()) {
income = "支出";
} else {
income = "收入";
}
String item = (String) cboItem.getSelectedItem();
String cont = txtMoney.getText();
if ("".equals(cont)) {
javax.swing.JOptionPane.showMessageDialog(this, "请输入金额！", "提示",
javax.swing.JOptionPane.ERROR_MESSAGE);
return;
}
//判断接收的数是否合法————是否是数字
for (int i = 0; i < cont.length(); i++) {
if ((cont.charAt(i) < '0' || cont.charAt(i) > '9')) {

javax.swing.JOptionPane.showMessageDialog(this,
"你输入的金额不合法！", "提示",
javax.swing.JOptionPane.ERROR_MESSAGE);
return;
}
}
String name = txtName.getText();
double money = Double.parseDouble(cont);

Calendar cal = Calendar.getInstance();
int y=cal.get(Calendar.YEAR );
int m=cal.get(Calendar.MONTH )+1;
int d=cal.get(Calendar.DATE);
int h=cal.get(Calendar.HOUR)+12;
int mi=cal.get(Calendar.MINUTE);
int s=cal.get(Calendar.SECOND);

String time = y+"-"+m+"-"+d+" "+h+":"+mi+":"+s;
DAO dao = new DAO();
if (dao.addBalance(item, income, money, name, time)) {
javax.swing.JOptionPane.showMessageDialog(this, "添加信息成功！",
"提示", javax.swing.JOptionPane.INFORMATION_MESSAGE);
} else {
javax.swing.JOptionPane.showMessageDialog(this, "添加信息失败！",
"提示", javax.swing.JOptionPane.ERROR_MESSAGE);
}
ArrayList al = new ArrayList();
al = dao.queryBalance(name);
txaInner.setText(al.toString());
} catch (java.lang.NumberFormatException nfe) {
nfe.printStackTrace();
}
}

private void txtNameActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}

private void cboItemActionPerformed(java.awt.event.ActionEvent evt) {
// TODO Auto-generated method stub
}

private void radInActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}

private void radOutActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}


public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new MainFram().setVisible(true);
}
});
}

//GEN-BEGIN:variables
// Variables declaration - do not modify
private javax.swing.JButton btnAdd;
private javax.swing.JButton btnRemake;
private javax.swing.ButtonGroup buttonGroup1;
private javax.swing.JComboBox cboItem;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JRadioButton radIn;
private javax.swing.JRadioButton radOut;
private javax.swing.JTextArea txaInner;
private javax.swing.JTextField txtMoney;
private javax.swing.JTextField txtName;
// End of variables declaration//GEN-END:variables

}

[baihua271314]

DAO.java

package Family;

import java.sql.*;
import java.sql.Date;
import java.util.*;
import Family.Bean;
import Family.DBUtil;

public class DAO {
/**
* 插入数据的方法
* @param item
* @param income
* @param count
* @param name
* @param time
* @return
*/
public boolean addBalance(String item,String income,double count,String name,String time) {
ArrayList al=new ArrayList();
DBUtil db=new DBUtil();
try {
java.sql.Connection con=db.getConnection();
String sql="insert into balance values(?,?,?,?,?)";
java.sql.PreparedStatement ps=con.prepareStatement(sql);
if(income == "支出") {
income="0";
}
else {
income="1";
}
ps.setString(1, item);
ps.setString(2, income);
ps.setDouble(3, count);
ps.setString(4, name);
ps.setString(5, time);

int sult=ps.executeUpdate();
if(sult>0) {
return true;
}
db.close(ps, con);
}
catch(java.sql.SQLException sqle) {
sqle.printStackTrace();
}
return false;

}

public ArrayList queryBalance(String name) {
ArrayList al=new ArrayList();
DBUtil db=new DBUtil();
try {
java.sql.Connection con=db.getConnection();
String sql="select * from balance where name=?";
java.sql.PreparedStatement ps=con.prepareStatement(sql);
ps.setString(1, name);

java.sql.ResultSet rs=ps.executeQuery();
Bean gb=new Bean();

while(rs.next()) {
gb.setMItem(rs.getString(2));
if(Integer.parseInt(rs.getString(3))==0) {
gb.setMIncome("支出");
}
else if(Integer.parseInt(rs.getString(3))==1){
gb.setMIncome("收入");
}

gb.setMMoney(rs.getDouble(4));
gb.setMName(rs.getString(5));
gb.setMTime(rs.getString(6));
al.add(gb.toString());
}
db.close(ps, rs, con);
}

catch(java.sql.SQLException sqle) {
sqle.printStackTrace();
}
return al;
}

}

[baihua271314]

Bean.java
package Family;

public class Bean {
private String mIncome;
private String mItem;
private double mMoney;
private String mName;
private String mTime;

public String getMIncome() {
return mIncome;
}
public void setMIncome(String income) {
mIncome = income;
}
public String getMItem() {
return mItem;
}
public void setMItem(String item) {
mItem = item;
}
public double getMMoney() {
return mMoney;
}
public void setMMoney(double money) {
mMoney = money;
}
public String getMName() {
return mName;
}
public void setMName(String name) {
mName = name;
}
public String getMTime() {
return mTime;
}
public void setMTime(String time) {
mTime = time;
}
public String toString() {
String str="\n"+mTime+" "+mIncome+" "+mItem+" "+mMoney+" "+mName+"\n";
return str;
}

}

DBUtil.java

package Family;

import java.sql.*;

public class DBUtil {
public java.sql.Connection getConnection() {
java.sql.Connection con=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con=java.sql.DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=finance","sa","");

}
catch(SQLException sqle) {
sqle.printStackTrace();
}
catch(java.lang.ClassNotFoundException cnfe) {
cnfe.printStackTrace();
}
return con;

}
public void close(java.sql.PreparedStatement ps,java.sql.ResultSet rs,java.sql.Connection con) {
try {
if(rs != null) {
rs.close();
}
if(ps != null) {
ps.close();
}
if(con != null) {
con.close();
}
}
catch(SQLException sqle) {
sqle.printStackTrace();
}

}
public void close(java.sql.PreparedStatement ps,java.sql.Connection con) {
try {

if(ps != null) {
ps.close();
}
if(con != null) {
con.close();
}
}
catch(SQLException sqle) {
sqle.printStackTrace();
}

}

}