📄 cat.java~4~
字号:
if (rs.next() ) {
jTextField2.setText(rs.getString(1));
jComboBox1.setSelectedItem(rs.getString(2));
jTextField4.setText(rs.getString(3));
jTextField5.setText(rs.getString(4));
jTextField6.setText(rs.getString(5));
String temp = rs.getString(6);
Countdays count = new Countdays(temp, c);
jTextField1.setText(" " + price_eachday * count.getdays());
//-----------------------------------------
if (rs.next()) morerows = true;
if (!morerows) {
String command = "DELETE FROM DATA WHERE idnumber LIKE" +
"'" + jTextField5.getText() + "'";
delete(command);
}
}
else
jTextArea1.append( "\n没找到记录\n" );
//-------------------------------------------
/* if(rs.next()) morerows=true;
if(!morerows)
{
String command = "DELETE FROM DATA WHERE name LIKE" +
"'" + jTextField2.getText() + "'";
delete(command);
}
}
else
jTextArea1.append( "\n没找到记录\n" );*/
if(morerows)
{
rs.beforeFirst();
String p="name"+"\t\t"+"rank_id"+"\n";
while(rs.next())
{
String temp=rs.getString(6);
Countdays count =new Countdays(temp,c);
String money=" "+price_eachday*count.getdays();
p=p+rs.getString( 1 )+"\t\t"+ rs.getString( 5 )+"\n";
}
jTextArea1.setText(p);
boolean judgeinput=false;
String rank="";
String command="";
rank=JOptionPane.showInputDialog(" 您要删除的人的姓名不止一个，请在信息栏中查看");
while(!judge_roomnum(rank))
{
rank=JOptionPane.showInputDialog("您输入的图书编号不合法，编号只能为1到100的数字，请您重新输入，谢谢！");
}
command= "DELETE FROM DATA WHERE name LIKE" + "'" + jTextField2.getText() + "'"+"AND rank_id LIKE"+"'"+rank + "'";
delete(command);
}
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void delete(String m)
{
try {
Statement statement = connect.createStatement();
//if ( !jTextField2.getText().equals( "" ) ) {
String query="";
// if(morethanone==false)
query = m;
/*if(morethanone==true)
{
boolean notblank=false;
if(!jTextField6.getText().equals(" "))
notblank=true;
if(notblank)
query = "DELETE FROM DATA WHERE name LIKE" + "'" + jTextField2.getText() + "'"+"AND rank_id LIKE"+"'"+jTextField6.getText() + "'";
}*/
jTextArea1.append("\n发送的命令:"+connect.nativeSQL(query)+"\n");
int result = statement.executeUpdate( query );
if ( result == 1 )
jTextArea1.append( "\n删除成功\n" );
else {
jTextArea1.append( "\n删除失败,请查看输入的图书编号是否正确。\n" );
jTextField2.setText( "" );
jComboBox1.setSelectedIndex(-1);
jTextField4.setText( "" );
jTextField5.setText( "" );
jTextField6.setText( "" );
}
// }
// else
// jTextArea1.append( "\n请您输入名子" );
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void jMenuItem1_actionPerformed(ActionEvent e) {
JTextArea t=new JTextArea(10,15);
t.setLineWrap(true);
t.setEditable(false);
JScrollPane p=new JScrollPane(t);
t.setText("随便做做.....");
JOptionPane.showMessageDialog(null,p,"谢谢使用！",JOptionPane.INFORMATION_MESSAGE);
}
void jButton4_actionPerformed(ActionEvent e) {
try {
Statement statement =connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String query = "SELECT * FROM DATA ";
jTextArea1.append( "\n发送的命令: " +
connect.nativeSQL( query )
+ "\n" );
ResultSet rs = statement.executeQuery( query );
findbook( rs );
jTextArea1.append( "\n查询成功\n" );
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void findbook(ResultSet r)
{
int m=0;
String emptybook=" ";
try {
if(r.next())
{
//r.beforeFirst();
for(int j=1;j<=10;j++)
{
r.first();
int full=0;
do
{
if(r.getString( 5 ).equals(Integer.toString(j)))
{
full=1;
break;
}
}
while(r.next());
if(full==1) continue;
else
{
emptybook = emptybook + " " + j;
if(++m%5==0) emptybook=emptybook+"\n";
}
}
}
else
{
jTextArea1.setText("");
jTextArea1.setText("全部图书在馆！");
}
jTextArea1.setText(emptybook);
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
boolean judge_age(String input)
{
int age;
try{
age = Integer.parseInt(input);
}catch(Exception e){
return false;
}
if((age >= 1) && (age <=100))
return true;
else
return false;
}
boolean judge_roomnum(String input)
{
int bnum;
try{
bnum = Integer.parseInt(input);
}catch(Exception e){
return false;
}
if((bnum >= 1) && (bnum <=100))
return true;
else
return false;
}
boolean namelegal()
{
if(!jTextField2.getText().equals("")&&jTextField2.getText().length()<=50)
return true;
else
{
message("必须输入姓名，且长度不能超过50");
return false;
}
}
boolean legal()
{
// if( judge_age(jTextField4.getText())&&judge_roomnum(jTextField6.getText()))
if(judge_age(jTextField4.getText()))
return true;
else{
message("年龄输入有误?请重新输入!");
jTextField4.setText("");
// jTextField6.setText("");
return false;
}
}
boolean judge_idnum(){
/* if(jTextField5.getText().length()==18)
{
String front1=jTextField5.getText().substring(0,4);
String front2=jTextField5.getText().substring(4,8);
String front3=jTextField5.getText().substring(8,12);
String front4=jTextField5.getText().substring(12,16);
String back=jTextField5.getText().substring(16,jTextField5.getText().length());
if(idnum(front1)&&idnum(front2)&&idnum(front3)&&idnum(front4)&&idnum(back))
return true;*/
if(!jTextField5.getText().equals("")&&jTextField5.getText().length()<=10)
return true;
/*
else
{
message("证号必须为10位的数字，请重新输入！");
jTextField5.setText("");
return false;
}*/
else
{
message("证号必须为10位的数字,请重新输入!");
jTextField5.setText("");
return false;
}
}
boolean idnum(String t)
{
try{
Integer.parseInt(t);
}catch(Exception e){
return false;
}
//数字范围在18至60的返回值是true
return true;
}
boolean judge_sex()
{
if(!jComboBox1.getSelectedItem().equals(""))
return true;
else
{
message("请选择类别");
return false;
}
}
void message(String t)
{
JOptionPane.showMessageDialog(null,t);
}
void jMenuItem2_actionPerformed(ActionEvent e) {
JTextArea t=new JTextArea(10,15);
t.setLineWrap(true);
t.setEditable(false);
JScrollPane p=new JScrollPane(t);
t.setText("采用微软的Access数据库实现。因此，请用户在使用前先安装微软的office，以便程序使用其中的Access。在用户安装完office后，请新建一个Access表数据库，使用文件夹中的DATA数据库。在完成以上操作后，请用户在要运行程序的计算机上安装odbc数据源。然后，用户就可以运行程序了！");
JOptionPane.showMessageDialog(null,p,"谢谢使用！",JOptionPane.INFORMATION_MESSAGE);
}
public static void main(String args[])
{
Cat app=new Cat();
app.addWindowListener(
new WindowAdapter(){
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
}
);
}
}
class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
Cat adaptee;
Frame1_jButton1_actionAdapter(Cat adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Frame1_jButton3_actionAdapter implements java.awt.event.ActionListener {
Cat adaptee;
Frame1_jButton3_actionAdapter(Cat adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class Frame1_jButton5_actionAdapter implements java.awt.event.ActionListener {
Cat adaptee;
Frame1_jButton5_actionAdapter(Cat adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
Cat adaptee;
Frame1_jButton2_actionAdapter(Cat adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class Frame1_jMenuItem1_actionAdapter implements java.awt.event.ActionListener {
Cat adaptee;
Frame1_jMenuItem1_actionAdapter(Cat adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuItem1_actionPerformed(e);
}
}
class Frame1_jButton4_actionAdapter implements java.awt.event.ActionListener {
Cat adaptee;
Frame1_jButton4_actionAdapter(Cat adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}
class Frame1_jMenuItem2_actionAdapter implements java.awt.event.ActionListener {
Cat adaptee;
Frame1_jMenuItem2_actionAdapter(Cat adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuItem2_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -