java写的备忘录,有新建,查看,修改,删除,提醒等功能。需要连接sql server数据库。
*************************
package memo;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.JTextArea.*;
import java.util.*;
import java.sql.*;
class MemoTest extends JFrame implements Runnable,ActionListener
{
Thread th1 = new Thread(this);
JFrame f;
JPanel p11,p12,p1,p2,p3,p4;
JLabel L1,L2,L3,L4;
JButton b1,b2,b3,b5;
public MemoTest()
{
th1.start();//开始线程
f=new JFrame("Memo");
f.setLayout(new GridLayout(4,1));
p11=new JPanel();
p12=new JPanel();
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
b1=new JButton(" 新 建 ");
b2=new JButton(" 查 询 ");
b3=new JButton(" 编 辑 ");
b5=new JButton(" 退 出 ");
L2 = new JLabel();
L3 = new JLabel();
L2.setText("***备 忘 录***");
L2.setFont(new Font("华文行楷",Font.BOLD,40));
L2.setForeground(Color.ORANGE );
L3.setHorizontalAlignment(JLabel.RIGHT);
p1.setBackground(new Color (205,255,105));
p2.setBackground(new Color (205,205,105));
p3.setBackground(new Color (255,205,105));
p4.setBackground(new Color (255,205,155));
p1.add(L2);
p2.add(b1);
p2.add(b2);
p2.add(b3);
p3.add(b5);
p4.add(L3);
f.add(p1);
f.add(p2);
f.add(p3);
f.add(p4);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b5.addActionListener(this);
f.setSize(600,350);
f.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
Object source=e.getSource();
if(source==b1)
{
creat guiWindow1=new creat();
}
else if(source==b2)
{
watch guiWindow1=new watch();
}
else if(source==b3)
{
alter guiWindow1=new alter();
}
else if(source==b5)
{
Thread.yield();
System.exit(0);
}
}
public void run()
{
try
{
while(!Thread.currentThread().isInterrupted())
{
Calendar cal = Calendar.getInstance();
int y = cal.get(Calendar.YEAR);
int mon = cal.get(Calendar.MONTH)+1;
int d = cal.get(Calendar.DATE);
int h = cal.get(Calendar.HOUR);
int min = cal.get(Calendar.MINUTE);
int s = cal.get(Calendar.SECOND);
int ap = cal.get(Calendar.AM_PM);
if(ap==1){
h = h+12;}
Connection con;
try{
/*Initialize and load the Type 4 driver*/
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=memo;","njut","1234");
/*Establish a connection with the database*/
/*Create an SQL statement*/
String str= " update memoss set second=0 where year=? and month=? and day=? and hour=? and minute=? and second=?";
PreparedStatement ps = con.prepareStatement(str);
ps.setInt(1,y);
ps.setInt(2,mon);
ps.setInt(3,d);
ps.setInt(4,h);
ps.setInt(5,min);
ps.setInt(6,s);
int count=ps.executeUpdate();
if(count>0)
{
java.awt.Toolkit.getDefaultToolkit().beep();
JOptionPane.showMessageDialog(null, "查看到期记录!", "提示", JOptionPane.CLOSED_OPTION);
}
con.close();
ps.close();
}
catch(Exception e1)
{
System.out.println("Error : " + e1);
}
L3.setText("一零二四制作 "+"日期:"+y+"-"+((mon<=9)?"0"+mon:mon)+"-"+((d<=9)?"0"+d:d)+" 时间:"+h+":"+((min<=9)?"0"+min:min)+":"+((s<=9)?"0"+s:s));
L3.setFont(new Font("宋体",Font.PLAIN,15));
Thread.sleep(1000);
}
}
catch(InterruptedException ee)
{}
}
public static void main(String args[])
{
MemoTest guiWindow=new MemoTest();
}
}
**************************************
package memo;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.JTextArea.*;
import java.util.*;
import java.sql.*;
public class creat extends JFrame implements ActionListener
{
int ye,mo,da,ho,mi,se,nu,tp=0;
String s1="无事", te;
Calendar cal = Calendar.getInstance();
int y = cal.get(Calendar.YEAR);
int mon = cal.get(Calendar.MONTH)+1;
int d = cal.get(Calendar.DATE);
int h = cal.get(Calendar.HOUR)+1;
int min = cal.get(Calendar.MINUTE);
int s = cal.get(Calendar.SECOND);
int ap = cal.get(Calendar.AM_PM);
JFrame f=new JFrame("Creat");
JPanel p1,p2,p3,p4,p5,p6,p7;
JPanel pa,pb,pc,pd,pe;
JLabel l1;
JButton b2=new JButton(" 确 定 ");
JTextArea t1=new JTextArea("开门见喜!",3,45);
JScrollPane scrollPane=new JScrollPane(t1);
private String[] year1 = { "","2010", "2011", "2012","2013", "2014", "2015","2016", "2017", "2018","2019", "2020"};
private String[] month1 = { "","1", "2","3", "4", "5","6", "7", "8","9", "10","11","12"};
private String[] day1 = { "","1", "2","3", "4", "5","6", "7", "8","9", "10","11","12", "13", "14", "15","16", "17", "18","19", "20","21","22", "23", "24", "25","26", "27", "28","29", "30","31"};
private String[] hour1 = { "","0" ,"1", "2","3", "4", "5","6", "7", "8","9", "10","11","12", "13", "14", "15","16", "17", "18","19", "20","21","22", "23"};
private String[] minute1 = { "","0", "1", "2","3", "4", "5","6", "7", "8","9", "10","11","12", "13", "14", "15","16", "17", "18","19", "20","21","22", "23", "24","25","26", "27", "28","29", "30","31","32", "33", "34","35","36", "37", "38","39", "40","41","42", "43", "44","45","46", "47", "48","49", "50","51","52", "53", "54","55","56", "57", "58","59"};
private String[] second1 = { "","0", "1", "2","3", "4", "5","6", "7", "8","9", "10","11","12", "13", "14", "15","16", "17", "18","19", "20","21","22", "23", "24","25","26", "27", "28","29", "30","31","32", "33", "34","35","36", "37", "38","39", "40","41","42", "43", "44","45","46", "47", "48","49", "50","51","52", "53", "54","55","56", "57", "58","59"};
private String[] number1 = { "","01", "02","03", "04", "05","06", "07", "08","09", "10","11","12"};
private JLabel inputJLabel1;
private JComboBox selectCountryJComboBox1;
private JLabel inputJLabel2;
private JComboBox selectCountryJComboBox2;
private JLabel inputJLabel3;
private JComboBox selectCountryJComboBox3;
private JLabel inputJLabel4;
private JComboBox selectCountryJComboBox4;
private JLabel inputJLabel5;
private JComboBox selectCountryJComboBox5;
private JLabel inputJLabel6;
private JComboBox selectCountryJComboBox6;
private JLabel inputJLabel7;
private JComboBox selectCountryJComboBox7;
public creat()
{
if(ap==1){ h = h+12;}
f.setLayout(new GridLayout(5,1));
t1.setLineWrap(true);
l1=new JLabel();
l1.setText("***新 建***");
l1.setFont(new Font("华文行楷",Font.BOLD,40));
l1.setForeground(Color.ORANGE );
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
p7=new JPanel();
pa=new JPanel();
pb=new JPanel();
pc=new JPanel();
pd=new JPanel();
pe=new JPanel();
pa.setBackground(new Color (205,255,105));
pb.setBackground(new Color (205,205,105));
pc.setBackground(new Color (255,205,105));
pd.setBackground(new Color (255,205,155));
pe.setBackground(new Color (205,205,155));
f.add(pa);
f.add(pb);
f.add(pc);
f.add(pd);
f.add(pe);
pa.add(l1);
pd.add(scrollPane);
pb.add(p1);
selectCountryJComboBox1 = new JComboBox( year1 );
selectCountryJComboBox1.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox1.setMaximumRowCount( 6 );
p1.add( selectCountryJComboBox1 );
inputJLabel1 = new JLabel();
inputJLabel1.setBounds( 390, 25, 135, 25 );
inputJLabel1.setText( "年:" );
p1.setBackground(new Color (205,205,105));
p1.add( inputJLabel1 );
if(y>=2010)
{y=y-2009;}
selectCountryJComboBox1.setSelectedIndex(y);
pb.add(p2);
selectCountryJComboBox2 = new JComboBox( month1 );
selectCountryJComboBox2.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox2.setMaximumRowCount( 6 );
p2.add( selectCountryJComboBox2 );
inputJLabel2 = new JLabel();
inputJLabel2.setBounds( 390, 25, 135, 25 );
inputJLabel2.setText( "月:" );
p2.setBackground(new Color (205,205,105));
p2.add( inputJLabel2 );
selectCountryJComboBox2.setSelectedIndex(mon);
pb.add(p3);
selectCountryJComboBox3 = new JComboBox( day1 );
selectCountryJComboBox3.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox3.setMaximumRowCount( 6 );
p3.add( selectCountryJComboBox3);
inputJLabel3 = new JLabel();
inputJLabel3.setBounds( 390, 25, 135, 25 );
inputJLabel3.setText( "日:" );
p3.setBackground(new Color (205,205,105));
p3.add( inputJLabel3 );
selectCountryJComboBox3.setSelectedIndex(d);
pc.add(p4);
selectCountryJComboBox4 = new JComboBox( hour1 );
selectCountryJComboBox4.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox4.setMaximumRowCount( 6 );
p4.add( selectCountryJComboBox4);
inputJLabel4 = new JLabel();
inputJLabel4.setBounds( 390, 25, 135, 25 );
inputJLabel4.setText( "时:" );
p4.setBackground(new Color (255,205,105));
p4.add( inputJLabel4 );
selectCountryJComboBox4.setSelectedIndex(h);
pc.add(p5);
selectCountryJComboBox5 = new JComboBox( minute1 );
selectCountryJComboBox5.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox5.setMaximumRowCount( 6 );
p5.add( selectCountryJComboBox5);
inputJLabel5 = new JLabel();
inputJLabel5.setBounds( 390, 25, 135, 25 );
inputJLabel5.setText( "分:" );
p5.setBackground(new Color (255,205,105));
p5.add( inputJLabel5 );
selectCountryJComboBox5.setSelectedIndex(min);
pc.add(p6);
selectCountryJComboBox6 = new JComboBox( second1 );
selectCountryJComboBox6.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox6.setMaximumRowCount( 6 );
p6.add( selectCountryJComboBox6);
inputJLabel6 = new JLabel();
inputJLabel6.setBounds( 390, 25, 135, 25 );
inputJLabel6.setText( "秒:" );
p6.setBackground(new Color (255,205,105));
p6.add( inputJLabel6 );
selectCountryJComboBox6.setSelectedIndex(s);
pe.add(p7);
selectCountryJComboBox7 = new JComboBox( number1 );
selectCountryJComboBox7.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox7.setMaximumRowCount( 6 );
p7.add( selectCountryJComboBox7);
inputJLabel7 = new JLabel();
inputJLabel7.setBounds( 390, 25, 135, 25 );
inputJLabel7.setText( "号记录:" );
p7.setBackground(new Color (205,205,155));
p7.add( inputJLabel7 );
selectCountryJComboBox7.setSelectedIndex(1);
pe.add(b2);
b2.addActionListener(this);
f.setSize(600,350);
f.setBackground(Color.BLACK);
f.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
int y;
y=selectCountryJComboBox1.getSelectedIndex();
switch(y)
{
case 0: break;
case 1: ye=2010; break;
case 2: ye=2011; break;
case 3: ye=2012; break;
case 4: ye=2013; break;
case 5: ye=2014; break;
case 6: ye=2015; break;
case 7: ye=2016; break;
case 8: ye=2017; break;
case 9: ye=2018; break;
case 10: ye=2019; break;
case 11: ye=2020; break;
}
int m;
m=selectCountryJComboBox2.getSelectedIndex();
switch(m)
{
case 0: break;
case 1: mo=1; break;case 2: mo=2; break;case 3: mo=3; break;case 4: mo=4; break;case 5: mo=5;break;
case 6: mo=6; break;case 7: mo=7; break;case 8: mo=8; break;case 9: mo=9; break;case 10: mo=10; break;
case 11: mo=11; break;case 12: mo=12;break;
}
int d;
d=selectCountryJComboBox3.getSelectedIndex();
switch(d)
{
case 0: break;
case 1: da=1; break;case 2: da=2; break;case 3: da=3; break;case 4: da=4; break;case 5: da=5;break;
case 6: da=6; break;case 7: da=7; break;case 8: da=8; break;case 9: da=9; break;case 10: da=10; break;
case 11: da=11; break;case 12: da=12; break;case 13: da=13; break;case 14: da=14; break;case 15: da=15;break;
case 16: da=16; break;case 17: da=17; break;case 18: da=18; break;case 19: da=19; break;case 20: da=20; break;
case 21: da=21; break;case 22: da=22; break;case 23: da=23; break;case 24: da=24; break;case 25: da=25;break;
case 26: da=26; break;case 27: da=27; break;case 28: da=28; break;case 29: da=29; break;case 30: da=30; break;
case 31: da=31; break;
}
int h;
h=selectCountryJComboBox4.getSelectedIndex();
switch(h)
{
case 0: break;
case 1: ho=0; break;case 2: ho=1; break;case 3: ho=2; break;case 4: ho=3; break;case 5: ho=4;break;
case 6: ho=5; break;case 7: ho=6; break;case 8: ho=7; break;case 9: ho=8; break;case 10: ho=9; break;
case 11: ho=10; break;case 12: ho=11; break;case 13: ho=12; break;case 14: ho=13; break;case 15: ho=14;break;
case 16: ho=15; break;case 17: ho=16; break;case 18: ho=17; break;case 19: ho=18; break;case 20: ho=19; break;
case 21: ho=20; break;case 22: ho=21; break;case 23: ho=22; break;case 24: ho=23; break;
}
int i;
i=selectCountryJComboBox5.getSelectedIndex();
switch(i)
{
case 0: break;
case 1: mi=0; break;case 2: mi=1; break;case 3: mi=2; break;case 4: mi=3; break;case 5: mi=4;break;
case 6: mi=5; break;case 7: mi=6; break;case 8: mi=7; break;case 9: mi=8; break;case 10: mi=9; break;
case 11: mi=10; break;case 12: mi=11; break;case 13: mi=12; break;case 14: mi=13; break;case 15: mi=14;break;
case 16: mi=15; break;case 17: mi=16; break;case 18: mi=17; break;case 19: mi=18; break;case 20: mi=19; break;
case 21: mi=20; break;case 22: mi=21; break;case 23: mi=22; break;case 24: mi=23; break;case 25: mi=24;break;
case 26: mi=25; break;case 27: mi=26; break;case 28: mi=27; break;case 29: mi=28; break;case 30: mi=29; break;
case 31: mi=30; break;case 32: mi=31; break;case 33: mi=32; break;case 34: mi=33; break;case 35: mi=34;break;
case 36: mi=35; break;case 37: mi=36; break;case 38: mi=37; break;case 39: mi=38; break;case 40: mi=39; break;
case 41: mi=40; break;case 42: mi=41; break;case 43: mi=42; break;case 44: mi=43; break;case 45: mi=44;break;
case 46: mi=45; break;case 47: mi=46; break;case 48: mi=47; break;case 49: mi=48; break;case 50: mi=49; break;
case 51: mi=50; break;case 52: mi=51; break;case 53: mi=52; break;case 54: mi=53; break;case 55: mi=54;break;
case 56: mi=55; break;case 57: mi=56; break;case 58: mi=57; break;case 59: mi=58; break;case 60: mi=59; break;
}
int s;
s=selectCountryJComboBox5.getSelectedIndex();
switch(s)
{
case 0: break;
case 1: se=0; break;case 2: se=1; break;case 3: se=2; break;case 4: se=3; break;case 5: se=4;break;
case 6: se=5; break;case 7: se=6; break;case 8: se=7; break;case 9: se=8; break;case 10: se=9; break;
case 11: se=10; break;case 12: se=11; break;case 13: se=12; break;case 14: se=13; break;case 15: se=14;break;
case 16: se=15; break;case 17: se=16; break;case 18: se=17; break;case 19: se=18; break;case 20: se=19; break;
case 21: se=20; break;case 22: se=21; break;case 23: se=22; break;case 24: se=23; break;case 25: se=24;break;
case 26: se=25; break;case 27: se=26; break;case 28: se=27; break;case 29: se=28; break;case 30: se=29; break;
case 31: se=30; break;case 32: se=31; break;case 33: se=32; break;case 34: se=33; break;case 35: se=34;break;
case 36: se=35; break;case 37: se=36; break;case 38: se=37; break;case 39: se=38; break;case 40: se=39; break;
case 41: se=40; break;case 42: se=41; break;case 43: se=42; break;case 44: se=43; break;case 45: se=44;break;
case 46: se=45; break;case 47: se=46; break;case 48: se=47; break;case 49: se=48; break;case 50: se=49; break;
case 51: se=50; break;case 52: se=51; break;case 53: se=52; break;case 54: se=53; break;case 55: se=54;break;
case 56: se=55; break;case 57: se=56; break;case 58: se=57; break;case 59: se=58; break;case 60: se=59; break;
}
int n;
n=selectCountryJComboBox7.getSelectedIndex();
switch(n)
{
case 0: break;
case 1: nu=1; break;
case 2: nu=2; break;
case 3: nu=3; break;
case 4: nu=4; break;
case 5: nu=5; break;
case 6: nu=6; break;
case 7: nu=7; break;
case 8: nu=8; break;
case 9: nu=9; break;
case 10: nu=10; break;
case 11: nu=11; break;
case 12: nu=12; break;
}
Object source=e.getSource();
if(source==b2)
{
try
{
te=t1.getText();
/*Initialize and load the Type 4 driver*/
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
/*Establish a connection with the database*/
Connection con = DriverManager.getConnection("jdbc:sqlserver://HU-PC:1433;databaseName=memo;","njut","1234");
/*Create an SQL statement*/
String str1= "update memoss set tip=null where number=?";
PreparedStatement ps1 = con.prepareStatement(str1);
ps1.setInt(1,nu);
int count1=ps1.executeUpdate();
if(count1==0)
{
String str2= "INSERT INTO dbo.memoss(number,year,month,day,hour,minute,second,text,tip) VALUES(?,?,?,?,?,?,?,?,?) ";
PreparedStatement ps2 = con.prepareStatement(str2);
ps2.setInt(1,nu);
ps2.setInt(2,ye);
ps2.setInt(3,mo);
ps2.setInt(4,da);
ps2.setInt(5,ho);
ps2.setInt(6,mi);
ps2.setInt(7,se);
ps2.setString(8,te);
ps2.setInt(9,1);
int count=ps2.executeUpdate();
JOptionPane.showMessageDialog(null, "新建成功!", "提示", JOptionPane.CLOSED_OPTION);
ps2.close();
}
else
{
String str3= "update memossset tip=1 where number=?";
PreparedStatement ps3 = con.prepareStatement(str3);
ps3.setInt(1,nu);
JOptionPane.showMessageDialog(null, "新建失败!记录已存在!", "提示", JOptionPane.CLOSED_OPTION);
ps3.close();
}
ps1.close();
}
catch(Exception e1)
{
System.out.println("Error : " + e1);
}
}
}
public static void main(String args[])
{
creat guiWindow=new creat();
}
}
***********************
package memo;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.JTextArea.*;
import java.util.*;
import java.sql.*;
public class watch extends JFrame implements ActionListener
{
int ye,mo,da,ho,mi,se,nu;
String te;
JFrame f=new JFrame("watch");
JPanel p1=new JPanel();
JPanel p2=new JPanel();
JPanel p3=new JPanel();
JPanel p4=new JPanel();
JLabel l1;
JButton b1=new JButton(" 确 定 ");
JTextArea t1=new JTextArea("好运当头!",5,50);
JScrollPane scrollPane=new JScrollPane(t1);
private String[] number = { "","01", "02","03", "04", "05","06", "07", "08","09", "10","11","12","所有记录"};
private JLabel inputJLabel4;
private JComboBox selectCountryJComboBox4;
public watch()
{
f.setLayout(new GridLayout(3,1));
t1.setLineWrap(true);
t1.setEditable(false);
JPanel p1=new JPanel();
JPanel p2=new JPanel();
JPanel p3=new JPanel();
JPanel p4=new JPanel();
JLabel l1=new JLabel();
l1.setText("***查 看***");
l1.setFont(new Font("华文行楷",Font.BOLD,40));
l1.setForeground(Color.ORANGE );
p1.setBackground(new Color (205,255,105));
p2.setBackground(new Color (205,205,105));
p3.setBackground(new Color (255,205,105));
p4.setBackground(new Color (255,205,105));
f.add(p1);
f.add(p2);
f.add(p3);
p1.add(l1);
p2.add(scrollPane);
p3.add(p4);
p3.add(b1);
selectCountryJComboBox4 = new JComboBox( number );
selectCountryJComboBox4.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox4.setMaximumRowCount( 6 );
p4.add( selectCountryJComboBox4);
inputJLabel4 = new JLabel();
inputJLabel4.setBounds( 390, 25, 135, 25 );
inputJLabel4.setText( "号记录:" );
selectCountryJComboBox4.setSelectedIndex(13);
p4.add( inputJLabel4 );
inputJLabel4.setBackground(new Color (255,205,105));
b1.addActionListener(this);
f.setSize(600,350);
f.setBackground(Color.BLACK);
f.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
boolean check=false;
int n;
n=selectCountryJComboBox4.getSelectedIndex();
switch(n)
{
case 0: break;
case 1: nu=1; break;
case 2: nu=2; break;
case 3: nu=3; break;
case 4: nu=4; break;
case 5: nu=5; break;
case 6: nu=6; break;
case 7: nu=7; break;
case 8: nu=8; break;
case 9: nu=9; break;
case 10: nu=10; break;
case 11: nu=11; break;
case 12: nu=12; break;
case 13: nu=13; break;
}
Object source=e.getSource();
if(source==b1)
{
java.awt.Toolkit.getDefaultToolkit().beep();
Connection con;
try
{
/*Initialize and load the Type 4 driver*/
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=memo;","njut","1234");
/*Establish a connection with the database*/
/*Create an SQL statement*/
String str= "select * from memoss where number=?";
PreparedStatement ps = con.prepareStatement(str);
if(nu<13)
{
ps.setInt(1,nu);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
check=true;
t1.setText(rs.getString(2)+"年"+rs.getString(3)+"月"+rs.getString(4)+"日"+rs.getString(5)+"时"+rs.getString(6)+"分"+rs.getString(7)+"秒/n"+rs.getString(1)+"号记录:"+rs.getString(8));
}
rs.close();
}
else
{
for(int r=1;r<13;r++)
{
ps.setInt(1,r);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
check=true;
t1.append("/n"+rs.getString(2)+"年"+rs.getString(3)+"月"+rs.getString(4)+"日"+rs.getString(5)+"时"+rs.getString(6)+"分"+rs.getString(7)+"秒/n"+rs.getString(1)+"号记录:"+rs.getString(8)+"/n"+"********************");
}
rs.close();
}
}
ps.close();
con.close();
}
catch(Exception e1)
{
System.out.println("Error : " + e1);
}
if(check)
{
JOptionPane.showMessageDialog(null, "查询成功!", "提示", JOptionPane.CLOSED_OPTION);
}
else
{
JOptionPane.showMessageDialog(null, "查询失败!重新选择记录!", "提示", JOptionPane.CLOSED_OPTION);
}
}
}
public static void main(String args[])
{
watch guiWindow=new watch();
}
}
***************************************
package memo;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.JTextArea.*;
import java.util.*;
import java.sql.*;
public class alter extends JFrame implements ActionListener
{
int ye,mo,da,ho,mi,se,nu;
String te;
JFrame f=new JFrame("alter");
JPanel p1,p2,p3,p4,p5,p6,p7;
JPanel pa=new JPanel();
JPanel pb=new JPanel();
JPanel pc=new JPanel();
JPanel pd=new JPanel();
JPanel pe=new JPanel();
JLabel l1;
JButton b1=new JButton(" 删 除 ");
JButton b2=new JButton(" 修 改 ");
JButton b3=new JButton(" 查 看 ");
JTextArea t1=new JTextArea("出入平安!",3,45);
JScrollPane scrollPane=new JScrollPane(t1);
private String[] year = { "","2010", "2011", "2012","2013", "2014", "2015","2016", "2017", "2018","2019", "2020"};
private String[] month = { "","1", "2","3", "4", "5","6", "7", "8","9", "10","11","12"};
private String[] day = { "","1", "2","3", "4", "5","6", "7", "8","9", "10","11","12", "13", "14", "15","16", "17", "18","19", "20","21","22", "23", "24", "25","26", "27", "28","29", "30","31"};
private String[] hour = { "","0","1", "2","3", "4", "5","6", "7", "8","9", "10","11","12", "13", "14", "15","16", "17", "18","19", "20","21","22", "23"};
private String[] minute = { "","0","1", "2","3", "4", "5","6", "7", "8","9", "10","11","12", "13", "14", "15","16", "17", "18","19", "20","21","22", "23", "24","25","26", "27", "28","29", "30","31","32", "33", "34","35","36", "37", "38","39", "40","41","42", "43", "44","45","46", "47", "48","49", "50","51","52", "53", "54","55","56", "57", "58","59"};
private String[] second = { "","0","1", "2","3", "4", "5","6", "7", "8","9", "10","11","12", "13", "14", "15","16", "17", "18","19", "20","21","22", "23", "24","25","26", "27", "28","29", "30","31","32", "33", "34","35","36", "37", "38","39", "40","41","42", "43", "44","45","46", "47", "48","49", "50","51","52", "53", "54","55","56", "57", "58","59"};
private String[] number ={ "","1", "2","3", "4", "5","6", "7", "8","9", "10","11","12"};
private JLabel inputJLabel1;
private JComboBox selectCountryJComboBox1;
private JLabel inputJLabel2;
private JComboBox selectCountryJComboBox2;
private JLabel inputJLabel3;
private JComboBox selectCountryJComboBox3;
private JLabel inputJLabel4;
private JComboBox selectCountryJComboBox4;
private JLabel inputJLabel5;
private JComboBox selectCountryJComboBox5;
private JLabel inputJLabel6;
private JComboBox selectCountryJComboBox6;
private JLabel inputJLabel7;
private JComboBox selectCountryJComboBox7;
public alter()
{
t1.setLineWrap(true);
JLabel l1=new JLabel("***编 辑***");
l1.setFont(new Font("华文行楷",Font.BOLD,40));
l1.setForeground(Color.ORANGE );
f.setLayout(new GridLayout(5,1));
JPanel p1=new JPanel();
JPanel p2=new JPanel();
JPanel p3=new JPanel();
JPanel p4=new JPanel();
JPanel p5=new JPanel();
JPanel p6=new JPanel();
JPanel p7=new JPanel();
pa.setBackground(new Color (205,255,105));
pb.setBackground(new Color (205,205,105));
pc.setBackground(new Color (255,205,105));
pd.setBackground(new Color (255,205,155));
pe.setBackground(new Color (205,205,155));
f.add(pa);
f.add(pb);
f.add(pc);
f.add(pd);
f.add(pe);
pa.add(l1);
pd.add(scrollPane);
pb.add(p1);
selectCountryJComboBox1 = new JComboBox( year );
selectCountryJComboBox1.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox1.setMaximumRowCount( 6 );
p1.add( selectCountryJComboBox1 );
inputJLabel1 = new JLabel();
inputJLabel1.setBounds( 390, 25, 135, 25 );
inputJLabel1.setText( "年:" );
p1.setBackground(new Color (205,205,105));
p1.add( inputJLabel1 );
selectCountryJComboBox1.setSelectedIndex(1);
pb.add(p2);
selectCountryJComboBox2 = new JComboBox( month );
selectCountryJComboBox2.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox2.setMaximumRowCount( 6 );
p2.add( selectCountryJComboBox2 );
inputJLabel2 = new JLabel();
inputJLabel2.setBounds( 390, 25, 135, 25 );
inputJLabel2.setText( "月:" );
p2.setBackground(new Color (205,205,105));
p2.add( inputJLabel2 );
selectCountryJComboBox2.setSelectedIndex(1);
pb.add(p3);
selectCountryJComboBox3 = new JComboBox( day );
selectCountryJComboBox3.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox3.setMaximumRowCount( 6 );
p3.add( selectCountryJComboBox3);
inputJLabel3 = new JLabel();
inputJLabel3.setBounds( 390, 25, 135, 25 );
inputJLabel3.setText( "日:" );
p3.setBackground(new Color (205,205,105));
p3.add( inputJLabel3 );
selectCountryJComboBox3.setSelectedIndex(1);
pc.add(p4);
selectCountryJComboBox4 = new JComboBox( hour );
selectCountryJComboBox4.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox4.setMaximumRowCount( 6 );
p4.add( selectCountryJComboBox4);
inputJLabel4 = new JLabel();
inputJLabel4.setBounds( 390, 25, 135, 25 );
inputJLabel4.setText( "时:" );
p4.setBackground(new Color (255,205,105));
p4.add( inputJLabel4 );
selectCountryJComboBox4.setSelectedIndex(1);
pc.add(p5);
selectCountryJComboBox5 = new JComboBox( minute );
selectCountryJComboBox5.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox5.setMaximumRowCount( 6 );
p5.add( selectCountryJComboBox5);
inputJLabel5 = new JLabel();
inputJLabel5.setBounds( 390, 25, 135, 25 );
inputJLabel5.setText( "分:" );
p5.setBackground(new Color (255,205,105));
p5.add( inputJLabel5 );
selectCountryJComboBox5.setSelectedIndex(1);
pc.add(p6);
selectCountryJComboBox6 = new JComboBox( second );
selectCountryJComboBox6.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox6.setMaximumRowCount( 6 );
p6.add( selectCountryJComboBox6);
inputJLabel6 = new JLabel();
inputJLabel6.setBounds( 390, 25, 135, 25 );
inputJLabel6.setText( "秒:" );
p6.setBackground(new Color (255,205,105));
p6.add( inputJLabel6 );
selectCountryJComboBox6.setSelectedIndex(1);
pe.add(p7);
selectCountryJComboBox7 = new JComboBox( number );
selectCountryJComboBox7.setBounds( 390, 50, 135, 21 );
selectCountryJComboBox7.setMaximumRowCount( 6 );
p7.add( selectCountryJComboBox7);
inputJLabel7 = new JLabel();
inputJLabel7.setBounds( 390, 25, 135, 25 );
inputJLabel7.setText( "号记录:" );
p7.setBackground(new Color (205,205,155));
p7.add( inputJLabel7 );
selectCountryJComboBox7.setSelectedIndex(1);
pe.add(p7);
pe.add(b3);
pe.add(b1);
pe.add(b2);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
f.setSize(600,350);
f.setBackground(Color.BLACK);
f.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
boolean check=false;
te=t1.getText();
int y;
y=selectCountryJComboBox1.getSelectedIndex();
switch(y)
{
case 0: break;
case 1: ye=2010; break;
case 2: ye=2011; break;
case 3: ye=2012; break;
case 4: ye=2013; break;
case 5: ye=2014; break;
case 6: ye=2015; break;
case 7: ye=2016; break;
case 8: ye=2017; break;
case 9: ye=2018; break;
case 10: ye=2019; break;
case 11: ye=2020; break;
}
int m;
m=selectCountryJComboBox2.getSelectedIndex();
switch(m)
{
case 0: break;
case 1: mo=1; break;case 2: mo=2; break;case 3: mo=3; break;case 4: mo=4; break;case 5: mo=5;break;
case 6: mo=6; break;case 7: mo=7; break;case 8: mo=8; break;case 9: mo=9; break;case 10: mo=10; break;
case 11: mo=11; break;case 12: mo=12;break;
}
int d;
d=selectCountryJComboBox3.getSelectedIndex();
switch(d)
{
case 0: break;
case 1: da=1; break;case 2: da=2; break;case 3: da=3; break;case 4: da=4; break;case 5: da=5;break;
case 6: da=6; break;case 7: da=7; break;case 8: da=8; break;case 9: da=9; break;case 10: da=10; break;
case 11: da=11; break;case 12: da=12; break;case 13: da=13; break;case 14: da=14; break;case 15: da=15;break;
case 16: da=16; break;case 17: da=17; break;case 18: da=18; break;case 19: da=19; break;case 20: da=20; break;
case 21: da=21; break;case 22: da=22; break;case 23: da=23; break;case 24: da=24; break;case 25: da=25;break;
case 26: da=26; break;case 27: da=27; break;case 28: da=28; break;case 29: da=29; break;case 30: da=30; break;
case 31: da=31; break;
}
int h;
h=selectCountryJComboBox4.getSelectedIndex();
switch(h)
{
case 0: break;
case 1: ho=0; break;case 2: ho=1; break;case 3: ho=2; break;case 4: ho=3; break;case 5: ho=4;break;
case 6: ho=5; break;case 7: ho=6; break;case 8: ho=7; break;case 9: ho=8; break;case 10: ho=9; break;
case 11: ho=10; break;case 12: ho=11; break;case 13: ho=12; break;case 14: ho=13; break;case 15: ho=14;break;
case 16: ho=15; break;case 17: ho=16; break;case 18: ho=17; break;case 19: ho=18; break;case 20: ho=19; break;
case 21: ho=20; break;case 22: ho=21; break;case 23: ho=22; break;case 24: ho=23; break;
}
int i;
i=selectCountryJComboBox5.getSelectedIndex();
switch(i)
{
case 0: break;
case 1: mi=0; break;case 2: mi=1; break;case 3: mi=2; break;case 4: mi=3; break;case 5: mi=4;break;
case 6: mi=5; break;case 7: mi=6; break;case 8: mi=7; break;case 9: mi=8; break;case 10: mi=9; break;
case 11: mi=10; break;case 12: mi=11; break;case 13: mi=12; break;case 14: mi=13; break;case 15: mi=14;break;
case 16: mi=15; break;case 17: mi=16; break;case 18: mi=17; break;case 19: mi=18; break;case 20: mi=19; break;
case 21: mi=20; break;case 22: mi=21; break;case 23: mi=22; break;case 24: mi=23; break;case 25: mi=24;break;
case 26: mi=25; break;case 27: mi=26; break;case 28: mi=27; break;case 29: mi=28; break;case 30: mi=29; break;
case 31: mi=30; break;case 32: mi=31; break;case 33: mi=32; break;case 34: mi=33; break;case 35: mi=34;break;
case 36: mi=35; break;case 37: mi=36; break;case 38: mi=37; break;case 39: mi=38; break;case 40: mi=39; break;
case 41: mi=40; break;case 42: mi=41; break;case 43: mi=42; break;case 44: mi=43; break;case 45: mi=44;break;
case 46: mi=45; break;case 47: mi=46; break;case 48: mi=47; break;case 49: mi=48; break;case 50: mi=49; break;
case 51: mi=50; break;case 52: mi=51; break;case 53: mi=52; break;case 54: mi=53; break;case 55: mi=54;break;
case 56: mi=55; break;case 57: mi=56; break;case 58: mi=57; break;case 59: mi=58; break;case 60: mi=59; break;
}
int s;
s=selectCountryJComboBox6.getSelectedIndex();
switch(s)
{
case 0: break;
case 1: se=0; break;case 2: se=1; break;case 3: se=2; break;case 4: se=3; break;case 5: se=4;break;
case 6: se=5; break;case 7: se=6; break;case 8: se=7; break;case 9: se=8; break;case 10: se=9; break;
case 11: se=10; break;case 12: se=11; break;case 13: se=12; break;case 14: se=13; break;case 15: se=14;break;
case 16: se=15; break;case 17: se=16; break;case 18: se=17; break;case 19: se=18; break;case 20: se=19; break;
case 21: se=20; break;case 22: se=21; break;case 23: se=22; break;case 24: se=23; break;case 25: se=24;break;
case 26: se=25; break;case 27: se=26; break;case 28: se=27; break;case 29: se=28; break;case 30: se=29; break;
case 31: se=30; break;case 32: se=31; break;case 33: se=32; break;case 34: se=33; break;case 35: se=34;break;
case 36: se=35; break;case 37: se=36; break;case 38: se=37; break;case 39: se=38; break;case 40: se=39; break;
case 41: se=40; break;case 42: se=41; break;case 43: se=42; break;case 44: se=43; break;case 45: se=44;break;
case 46: se=45; break;case 47: se=46; break;case 48: se=47; break;case 49: se=48; break;case 50: se=49; break;
case 51: se=50; break;case 52: se=51; break;case 53: se=52; break;case 54: se=53; break;case 55: se=54;break;
case 56: se=55; break;case 57: se=56; break;case 58: se=57; break;case 59: se=58; break;case 60: se=59; break;
}
int n;
n=selectCountryJComboBox7.getSelectedIndex();
switch(n)
{
case 0: break;
case 1: nu=1; break;
case 2: nu=2; break;
case 3: nu=3; break;
case 4: nu=4; break;
case 5: nu=5; break;
case 6: nu=6; break;
case 7: nu=7; break;
case 8: nu=8; break;
case 9: nu=9; break;
case 10: nu=10; break;
case 11: nu=11; break;
case 12: nu=12; break;
}
Object source=e.getSource();
if(source==b1)
{
java.awt.Toolkit.getDefaultToolkit().beep();
Connection con;
try
{
/*Initialize and load the Type 4 driver*/
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=memo;","njut","1234");
/*Establish a connection with the database*/
/*Create an SQL statement*/
String str= " delete from memoss where number=?";
PreparedStatement ps = con.prepareStatement(str);
ps.setInt(1,nu);
int count=ps.executeUpdate();
if(count==0)
{
JOptionPane.showMessageDialog(null, "删除失败!记录不存在!", "提示", JOptionPane.CLOSED_OPTION);
}
else
{
JOptionPane.showMessageDialog(null, "删除成功!", "提示", JOptionPane.CLOSED_OPTION);
}
}
catch(Exception e1)
{
System.out.println("Error : " + e1);
}
}
else if(source==b2)
{
java.awt.Toolkit.getDefaultToolkit().beep();
Connection con;
try
{
/*Initialize and load the Type 4 driver*/
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=memo;","njut","1234");
/*Establish a connection with the database*/
/*Create an SQL statement*/
String str2= "update memoss set year=?,month=?,day=?,hour=?,minute=?,second=?,text=? where number=?";
PreparedStatement ps2 = con.prepareStatement(str2);
ps2.setInt(1,ye);
ps2.setInt(2,mo);
ps2.setInt(3,da);
ps2.setInt(4,ho);
ps2.setInt(5,mi);
ps2.setInt(6,se);
ps2.setString(7,te);
ps2.setInt(8,nu);
int count=ps2.executeUpdate();
if(count==0)
{
JOptionPane.showMessageDialog(null, "修改失败!记录不存在!", "提示", JOptionPane.CLOSED_OPTION);
}
else
{
JOptionPane.showMessageDialog(null, "修改成功!", "提示", JOptionPane.CLOSED_OPTION);
}
}
catch(Exception e1)
{
System.out.println("Error : " + e1);
}
}
else if(source==b3)
{
java.awt.Toolkit.getDefaultToolkit().beep();