备忘录 java

最新推荐文章于 2023-05-26 09:57:19 发布

huzk4409

最新推荐文章于 2023-05-26 09:57:19 发布

阅读量852

点赞数 1

分类专栏： java 文章标签： string import sqlserver exception database null

本文链接：https://blog.csdn.net/huzk4409/article/details/5668588

版权

java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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);