代码如下,调试了很久,没调好,帮忙看下,,,JAVA初学者,,谢谢了!明天要交这个作业,急死了,,,package quaryExcutor;
import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;//用于在已经建立数据库连接的基础上,向数据库发送要执行的SQL语句。
import javax.swing.BoxLayout;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
public class go extends JFrame
{
private static final long serialVersionUID = 1L;
private JLabel l1;
private JLabel l2;
private JTextField sql;
private JButton ex;
private JFrame jf;public go()
{
jf.setTitle("SQL查询执行器");
jf.setSize(500, 150);
jf.setVisible(true);
jf.setLocationRelativeTo(null);///使窗口显示到中间
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//使用 System exit 方法退出应用程序
l1=new JLabel("请输入要执行的SQL语句:");
l2=new JLabel("执行结果");
sql=new JTextField();
sql.addKeyListener(new KeyAdapter()
{
public void keyPressed(KeyEvent e)
{
if(e.getKeyCode()==KeyEvent.VK_ENTER)
{
}
}
});
ex=new JButton("执行");
ex.addActionListener(new exlistener());
JPanel inputpanel=new JPanel();
JPanel buttonpanel=new JPanel();
inputpanel.setLayout(new BoxLayout(inputpanel,BoxLayout.Y_AXIS));//垂直排列
buttonpanel.setLayout(new FlowLayout());//居中对齐
inputpanel.add(l1);
inputpanel.add(sql);
inputpanel.add(l2);
buttonpanel.add(ex);
this.getContentPane().add(inputpanel,BorderLayout.NORTH);
this.getContentPane().add(buttonpanel,BorderLayout.SOUTH);
}
}
try {
Connection con=DriverManager.getConnection("user/db/schema");
Statement stmt=con.createStatement();
String SQL=sql.getText();
stmt.execute(SQL);
l2.setText("执行成功!");//将l2上面的文字设置为"执行成功!"
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, "SQL语句输入有误或者该操作非法!","警告",JOptionPane.WARNING_MESSAGE);
l2.setText("无法执行!");
e.printStackTrace();
}
}public class exlistener implements ActionListener{
public void actionPerformed(ActionEvent ev) {
//excute();
}
}
}
import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;//用于在已经建立数据库连接的基础上,向数据库发送要执行的SQL语句。
import javax.swing.BoxLayout;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
public class go extends JFrame
{
private static final long serialVersionUID = 1L;
private JLabel l1;
private JLabel l2;
private JTextField sql;
private JButton ex;
private JFrame jf;public go()
{
jf.setTitle("SQL查询执行器");
jf.setSize(500, 150);
jf.setVisible(true);
jf.setLocationRelativeTo(null);///使窗口显示到中间
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//使用 System exit 方法退出应用程序
l1=new JLabel("请输入要执行的SQL语句:");
l2=new JLabel("执行结果");
sql=new JTextField();
sql.addKeyListener(new KeyAdapter()
{
public void keyPressed(KeyEvent e)
{
if(e.getKeyCode()==KeyEvent.VK_ENTER)
{
}
}
});
ex=new JButton("执行");
ex.addActionListener(new exlistener());
JPanel inputpanel=new JPanel();
JPanel buttonpanel=new JPanel();
inputpanel.setLayout(new BoxLayout(inputpanel,BoxLayout.Y_AXIS));//垂直排列
buttonpanel.setLayout(new FlowLayout());//居中对齐
inputpanel.add(l1);
inputpanel.add(sql);
inputpanel.add(l2);
buttonpanel.add(ex);
this.getContentPane().add(inputpanel,BorderLayout.NORTH);
this.getContentPane().add(buttonpanel,BorderLayout.SOUTH);
}
}
try {
Connection con=DriverManager.getConnection("user/db/schema");
Statement stmt=con.createStatement();
String SQL=sql.getText();
stmt.execute(SQL);
l2.setText("执行成功!");//将l2上面的文字设置为"执行成功!"
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, "SQL语句输入有误或者该操作非法!","警告",JOptionPane.WARNING_MESSAGE);
l2.setText("无法执行!");
e.printStackTrace();
}
}public class exlistener implements ActionListener{
public void actionPerformed(ActionEvent ev) {
//excute();
}
}
}
解决方案 »
- Jframe 如何去掉热咖啡图标
- Properties类中的put方法改掉默认GBK编码方式引发的小问题!
- java 去除颜色值?
- 请大家推荐一本关于设计模式的书籍,要通俗易懂!最好是java语言描述的
- 莫名错误javax.swing.plaf.metal.MetalBorders$ScrollPaneBorder.paintBorder(MetalBorders.java:783)
- 泛型不会用啊!请指教一下!
- 求两个日期之间相差的天数 数据库是MYSQL
- java中如何调用其它程序呀?
- 谁家在福州?低价卖java好书
- 关于 swich 语句的一个疑问,请帮忙看一下。
- 菜鸟求解一个java简单问题
- 准备写个检查代码词法、格式的小工具,大家伙觉得该如何入手、或者有推荐些资料?
Connection con=DriverManager.getConnection("user/db/schema"); // 这行代码错了
stmt.execute(SQL); // 如果你用的是查询语句,那么这里就要改成exeQuery();