麻烦大家看一下本人的代码,主要功能是进行数据库(sql server)的添加,删除,更新,编译通过,但运行不出来,我想主要是没有连接好数据库:
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class MainClass
{ public static void main(String args[])
{ new ManagerWindow();
}
}
class ManagerWindow extends Frame implements ActionListener
{ Input input;Delet del;Qury qury;
Button a,b,c,h;shujuku shuu=new shujuku();Statement sql;
ResultSet rs;TextArea text;
ManagerWindow()
{ a=new Button("添加");
a.addActionListener(this);
b=new Button("删除");shuu.shuju();
c=new Button("查询");h=new Button("刷新");
b.addActionListener(this);h.addActionListener(this);
c.addActionListener(this);
text=new TextArea(7,10);
try { text.append("学号:"+rs.getString(1)+"姓名:"+rs.getString(2)+"\n");}
catch(Exception eee){}
add(b);add(a);add(c);add(text);
input=new Input(this);qury=new Qury(this);
del=new Delet(this); setLayout(new FlowLayout());
setVisible(true);
} public void actionPerformed(ActionEvent e)
{ if(e.getSource()==a)
input.setVisible(true);
else if(e.getSource()==b)
del.setVisible(true);
else if(e.getSource()==c)
qury.setVisible(true);
else if(e.getSource()==h)
try{ text.append("学号:"+rs.getString(1)+"姓名:"+rs.getString(2)+"\n");}
catch(Exception ee) {}
}
}
class Input extends Dialog implements ActionListener
{ TextField number1,name1;
Button d;shujuku shu=new shujuku();Statement sql;
ResultSet rs;
Input(Frame f)
{ super(f,"添加对话框",false);
setLayout(new FlowLayout());
number1=new TextField();
name1=new TextField();
d=new Button("确定");
d.addActionListener(this);add(new Label("学号:",Label.CENTER));
add(number1);add(new Label("姓名",Label.CENTER));
add(name1);
add(d);
//setVisible(true);
}
public void actionPerformed(ActionEvent e)
{ shu.shuju();
String s1=number1.getText(),s2=name1.getText();
try { sql.executeUpdate("INSERT INTO xueshentbiao VALUES (s1,s2)");}
catch(Exception ee) {}
}
}
class Delet extends Dialog implements ActionListener
{
TextField number1,name1;
Button d;shujuku shu=new shujuku();Statement sql;
ResultSet rs;
Delet(Frame f)
{ super(f,"删除对话框",false);
setLayout(new FlowLayout());
number1=new TextField();
name1=new TextField();
d=new Button("确定");
d.addActionListener(this);
add(number1);add(name1);add(d);
//setVisible(true);
} public void actionPerformed(ActionEvent e)
{ shu.shuju();
String s1=number1.getText(),s2=name1.getText();
try { sql.executeUpdate("DELETE FROM xueshengbiao WHERE number=s1");} catch(Exception ee) {}
}
}
class Qury extends Dialog implements ActionListener
{ Label l=new Label("任选一项查询");
TextField number1,name1;
shujuku shu=new shujuku();Statement sql;
ResultSet rs;
Qury(Frame f)
{ super(f,"查询对话框",false);
setLayout(new FlowLayout());
number1=new TextField();
name1=new TextField();add(new Label("学号:",Label.CENTER));
add(number1);add(new Label("姓名",Label.CENTER));add(name1);add(l);
//setVisible(true); number1.addActionListener(this);
name1.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{ try{ shu.shuju();
if(e.getSource()==number1)
{ rs=sql.executeQuery("SELECT * FROM xueshentbiao where number='number1.getText().toString'");
String name=rs.getString(2);name1.setText(name); }
else if(e.getSource()==name1)
{ rs=sql.executeQuery("SELECT * FROM xueshentbiao where name='name1.getText().toString'");
String number=rs.getString(2);number1.setText(number); }
} catch(Exception eeee){} }
}
class shujuku
{ public void shuju()
{ Connection con;
Statement sql;
ResultSet rs;String number,name;
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException e)
{ System.out.println(" "+e);}
try { con=DriverManager.getConnection("jdbc:odbc:ab","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM xueshengbiao"); while(rs.next())
{ number=rs.getString(1);
name=rs.getString(2);
//System.out.println("学号:"+number);
//System.out.println("姓名"+name);
}
con.close(); }
catch(SQLException e)
{ System.out.println(e);
}
}
}
感谢读完我的烂码,有何赐教,不胜感激!!!!!!!!!
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class MainClass
{ public static void main(String args[])
{ new ManagerWindow();
}
}
class ManagerWindow extends Frame implements ActionListener
{ Input input;Delet del;Qury qury;
Button a,b,c,h;shujuku shuu=new shujuku();Statement sql;
ResultSet rs;TextArea text;
ManagerWindow()
{ a=new Button("添加");
a.addActionListener(this);
b=new Button("删除");shuu.shuju();
c=new Button("查询");h=new Button("刷新");
b.addActionListener(this);h.addActionListener(this);
c.addActionListener(this);
text=new TextArea(7,10);
try { text.append("学号:"+rs.getString(1)+"姓名:"+rs.getString(2)+"\n");}
catch(Exception eee){}
add(b);add(a);add(c);add(text);
input=new Input(this);qury=new Qury(this);
del=new Delet(this); setLayout(new FlowLayout());
setVisible(true);
} public void actionPerformed(ActionEvent e)
{ if(e.getSource()==a)
input.setVisible(true);
else if(e.getSource()==b)
del.setVisible(true);
else if(e.getSource()==c)
qury.setVisible(true);
else if(e.getSource()==h)
try{ text.append("学号:"+rs.getString(1)+"姓名:"+rs.getString(2)+"\n");}
catch(Exception ee) {}
}
}
class Input extends Dialog implements ActionListener
{ TextField number1,name1;
Button d;shujuku shu=new shujuku();Statement sql;
ResultSet rs;
Input(Frame f)
{ super(f,"添加对话框",false);
setLayout(new FlowLayout());
number1=new TextField();
name1=new TextField();
d=new Button("确定");
d.addActionListener(this);add(new Label("学号:",Label.CENTER));
add(number1);add(new Label("姓名",Label.CENTER));
add(name1);
add(d);
//setVisible(true);
}
public void actionPerformed(ActionEvent e)
{ shu.shuju();
String s1=number1.getText(),s2=name1.getText();
try { sql.executeUpdate("INSERT INTO xueshentbiao VALUES (s1,s2)");}
catch(Exception ee) {}
}
}
class Delet extends Dialog implements ActionListener
{
TextField number1,name1;
Button d;shujuku shu=new shujuku();Statement sql;
ResultSet rs;
Delet(Frame f)
{ super(f,"删除对话框",false);
setLayout(new FlowLayout());
number1=new TextField();
name1=new TextField();
d=new Button("确定");
d.addActionListener(this);
add(number1);add(name1);add(d);
//setVisible(true);
} public void actionPerformed(ActionEvent e)
{ shu.shuju();
String s1=number1.getText(),s2=name1.getText();
try { sql.executeUpdate("DELETE FROM xueshengbiao WHERE number=s1");} catch(Exception ee) {}
}
}
class Qury extends Dialog implements ActionListener
{ Label l=new Label("任选一项查询");
TextField number1,name1;
shujuku shu=new shujuku();Statement sql;
ResultSet rs;
Qury(Frame f)
{ super(f,"查询对话框",false);
setLayout(new FlowLayout());
number1=new TextField();
name1=new TextField();add(new Label("学号:",Label.CENTER));
add(number1);add(new Label("姓名",Label.CENTER));add(name1);add(l);
//setVisible(true); number1.addActionListener(this);
name1.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{ try{ shu.shuju();
if(e.getSource()==number1)
{ rs=sql.executeQuery("SELECT * FROM xueshentbiao where number='number1.getText().toString'");
String name=rs.getString(2);name1.setText(name); }
else if(e.getSource()==name1)
{ rs=sql.executeQuery("SELECT * FROM xueshentbiao where name='name1.getText().toString'");
String number=rs.getString(2);number1.setText(number); }
} catch(Exception eeee){} }
}
class shujuku
{ public void shuju()
{ Connection con;
Statement sql;
ResultSet rs;String number,name;
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException e)
{ System.out.println(" "+e);}
try { con=DriverManager.getConnection("jdbc:odbc:ab","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM xueshengbiao"); while(rs.next())
{ number=rs.getString(1);
name=rs.getString(2);
//System.out.println("学号:"+number);
//System.out.println("姓名"+name);
}
con.close(); }
catch(SQLException e)
{ System.out.println(e);
}
}
}
感谢读完我的烂码,有何赐教,不胜感激!!!!!!!!!
我改一下jdbc的部分
界面出来了
但是功能还没有实现
不知道你想作什么