import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
class ceshi3 extends JFrame implements ActionListener
{
JTextArea jta=new JTextArea(10,30);
JTextField jf=new JTextField(10);
JButton jb=new JButton("搜索");
JButton jb2=new JButton("清屏");
JScrollPane js=new JScrollPane(jta);
String str;
//char ch[10];
String mabiao,yuanying;
Statement stmt;
String sql,id,xinxi;
ResultSet rs;
Pattern p=null;
Matcher m=null;
boolean b=false;
public ceshi3(){
JPanel jpanel=new JPanel();
jta.setLineWrap(true);
//jta.setBackground(Color.pink);
JLabel jl2=new JLabel("解释信息");
JLabel jt=new JLabel("输入检测信息");
jl2.setForeground(Color.blue);
jt.setForeground(Color.red);
this.setSize(450,350);
this.setLocation(300,200);
this.setVisible(true);
this.setResizable(false);
this.add(jpanel);
jpanel.add(jl2);
jpanel.add(js);
jpanel.add(jt);
jpanel.add(jf);
jpanel.add(jb);
jpanel.add(jb2);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jb.addActionListener(this);
jb2.addActionListener(this);
jta.setFont(new Font("隶书", Font.PLAIN, 15));
jf.setFont(new Font("SansSerif", Font.BOLD, 16));
}
public void actionPerformed(ActionEvent e)
{
if(e.getActionCommand().equals("清屏"))
jta.setText("");
if(e.getActionCommand().equals("搜索"))
{
jta.setText("");
str=jf.getText().trim();
if(jf.getText().equals(""))
JOptionPane.showMessageDialog(null,"信息不能为空!!","错误信息",JOptionPane.ERROR_MESSAGE);
else{
p=Pattern.compile("[0-9[A-Z]]+$");
m=p.matcher(str);
b=m.matches();
//System.out.println("b="+b);
if(b==false||str.length()!=2)//限制输入长度
JOptionPane.showMessageDialog(null,"输入有误!请重新输入","错误信息",JOptionPane.ERROR_MESSAGE);
else{
try{
Class.forName("com.mysql.jdbc.Driver"); }
catch(Exception e1){
JOptionPane.showMessageDialog(null,"无法加载驱动程序","错误信息",JOptionPane.ERROR_MESSAGE);
//System.out.println("无法加载驱动程序");
}
try{
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sb_jc","root","123");
if(!con.isClosed())
//System.out.println("数据库连接成功!!!");
stmt = con.createStatement();
sql="select * from jcxx where mabiao='"+str+"'";
//System.out.println(sql+"\r\n");
rs=stmt.executeQuery(sql);
jta.append("查询结果如下:"+"\r\n");
while(rs.next())
{
id=rs.getString(1);
xinxi=rs.getString(2);
//jta.setText("\r\n");
jta.append(id+" "+xinxi+"\r\n");
// System.out.println(id+" "+xinxi);
}
stmt.close();
con.close();}
catch(SQLException ee){
JOptionPane.showMessageDialog(null,"数据库连接失败","错误信息",JOptionPane.ERROR_MESSAGE);
//System.out.println("数据库连接失败");
}
}
}
jf.setText("");
}
}
public static void main(String[] args)
{
ceshi3 cs=new ceshi3();
}
}