Java核心代码Java核心代码.doc
文本预览下载声明
public void actionPerformed(ActionEvent e) {
Connection con;
Statement sql;
ResultSet rs;
Boolean bool = false;
int num = 0;
try{
con = DriverManager.getConnection(jdbc:odbc:myData, , );
sql = con.createStatement();
rs = sql.executeQuery(SELECT * FROM Student );
num=Integer.parseInt(DeleteWindow.number.getText());
while(rs.next())//java.sql.ResultSet中方法，包括getString、getInt
{
int num1 =rs.getInt(1);//获取表中学号信息,参数为第几列的值
String name1=rs.getString(2);
if (num==num1) {
bool=true;
break;
}
}
}
catch(Exception ee){
System.out.print(ee);
}
try{
if(bool==false)
{
textshow.append(学号不存在，请重新输入！！\n);
}
else{
ModifyTable modify=new ModifyTable();
modify.setDatasourceName(myData);
String s2=String.format(delete from Student where number=%d,num);
modify.setSQL(s2);
String backMess=modify.modifyRecord();
System.out.println(backMess);
textshow.append(操作成功！！\n);
}
}
catch(Exception exp){
textshow.append(请输入正确学号！！\n);
}
}
JTextArea textShow;
public void actionPerformed(ActionEvent e) {
DeleteWindow dele=new DeleteWindow();
dele.setBounds(600,250,300,300);
dele.setTitle(删除学生信息);
}
}
//插入窗口布局
class DeleteWindow extends JFrame{
static JTextField number;
JButton button1,button2;
DeleteListener delete;
JTextArea textshow;
public DeleteWindow() {
init();
setVisible(true);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
}
void init() {
setLayout(new FlowLayout());
number=new JTextField(8);
button1=new JButton(确定);
button2=new JButton(取消);
delete=new DeleteListener();//监听器
textshow=new JTextArea(4,20);
delete.setJTextArea(textshow);
add(new JLabel(——————输入要删除的学生学号——————));
add(new JLabel(学号：));
add(number);
add(new JLabel(————————————————————));
add(button1);
add(button2);
button1.addActionListener(delete);
//一下代码为点击“取消按钮退出输入窗口”
button2.addActionListener(n
显示全部