java.sql.SQLException：数据库锁定 [英] java.sql.SQLException:Database Locked

问题描述

我有问题java.sql.SQLException：Database Locked这个。我对我的程序做了一个登录屏幕，之后它打开一个我设计的jFrame。我做了一个小按钮，这是工作将数据保存在jtextfields到数据库，并显示他们的jtable是紧挨着textfield。但填充jtextfields后，当我点击这个按钮，它给我java.sql.SQLException：数据库锁定的错误。我正在等待您的帮助

PS：如果您需要登录屏幕或任何其他内容，只需留下评论或回答，我可以编辑此问题。

  private void cmd_saveActionPerformed（java.awt.event.ActionEvent evt）{
 
 try {
 String sql =Insert into maintable（\Ad-Soyad \，Yaş，Konum，\E-Posta \，\KatılımTarihi \）values（？，？，？，？ ）; 
 
 pst = conn.prepareStatement（sql）; 
 
 pst.setString（1，jTextField1.getText（））; 
 pst.setString（2，jTextField2.getText（））; 
 pst.setString（3，jTextField3.getText（））; 
 pst.setString（4，jTextField4.getText（））; 
 pst.setString（5，jTextField5.getText（））; 
 
 pst.execute（）; 
 JOptionPane.showMessageDialog（null，Kaydedildi！）; 
 
} catch（Exception e）{
 JOptionPane.showMessageDialog（null，e）; 
} 
} 
  

编辑：现在点击按钮后， Kaydedildi的消息，这是成功的英语。但它显示我另一个错误。

  private void Table_EmployeeMouseClicked（java.awt.event.MouseEvent evt）{
 // TODO在这里添加你的处理代码：
 
 try {
 int row = Table_Employee.getSelectedRow（）; 
 String Table_click =（Table_Employee.getModel（）。getValueAt（row，0）.toString（））; 
 String sql =select * from maintable whereİsim='+ Table_click +'; 
 pst = conn.prepareStatement（sql）; 
 rs = pst.executeQuery（）; 
 if（rs.next（））{
 
 String add1 = rs.getString（İsim）; 
 jTextField1.setText（（rs.getString（İsim））。trim（））; 
 
 String add2 = rs.getString（Yaş）; 
 jTextField2.setText（（rs.getString（Yaş））。trim（））; 
 
 String add3 = rs.getString（Konum）; 
 jTextField3.setText（（rs.getString（Konum））。trim（））; 
 
 String add4 = rs.getString（EPosta）; 
 jTextField4.setText（（rs.getString（EPosta））。trim（））; 
 
 String add5 = rs.getString（KatılımTarihi）; 
 jTextField5.setText（（rs.getString（KatılımTarihi））。trim（））; 
 
 
 
 
} 
 
 
} catch（Exception e）{
 JOptionPane.showMessageDialog（null， e）。 
 
 
 
} 
 
 
 
 
 
 
} 
 

这不是插入pst.execute（）的方法。


使用此方式

  pst.executeUpdate 
  




I'm having problem "java.sql.SQLException:Database Locked" with this. I did a login screen to my program, after that it's opening a jFrame which i designed. And i made a little button which is working for saving datas in jtextfields into database and showing them to jtable which is right next to the textfield. But after filling jtextfields, when i click to this button, it's giving me "java.sql.SQLException:Database Locked" error. I'm waiting for your helps

PS:If you need login screen's or anything else,just leave a comment or answer, i can edit this question.

private void cmd_saveActionPerformed(java.awt.event.ActionEvent evt) {                                         

      try{          
          String sql="Insert into maintable(\"Ad-Soyad\",Yaş,Konum,\"E-Posta\",\"Katılım Tarihi\") values (?,?,?,?,?)";

          pst=conn.prepareStatement(sql);

          pst.setString(1, jTextField1.getText());
          pst.setString(2, jTextField2.getText());
          pst.setString(3, jTextField3.getText());
          pst.setString(4, jTextField4.getText());
          pst.setString(5, jTextField5.getText());          

          pst.execute();
          JOptionPane.showMessageDialog(null, "Kaydedildi !"); 

          } catch(Exception e) {          
                JOptionPane.showMessageDialog(null,e);
            }             
          }  

EDIT:Now after clicking button, it's coming up "Kaydedildi " message which is succesfull in english. But it's showing me an another error.

private void Table_EmployeeMouseClicked(java.awt.event.MouseEvent evt) {                                            
// TODO add your handling code here:

        try{
         int row =Table_Employee.getSelectedRow();
         String Table_click=(Table_Employee.getModel().getValueAt(row, 0).toString());
         String sql ="select * from maintable where İsim ='"+Table_click+"' ";
         pst=conn.prepareStatement(sql);
         rs=pst.executeQuery();
         if(rs.next()){

         String add1 =rs.getString("İsim");
         jTextField1.setText((rs.getString("İsim")).trim());

         String add2 =rs.getString("Yaş");
         jTextField2.setText((rs.getString("Yaş")).trim());

         String add3 =rs.getString("Konum");
         jTextField3.setText((rs.getString("Konum")).trim());

         String add4 =rs.getString("EPosta");
         jTextField4.setText((rs.getString("EPosta")).trim());

         String add5 =rs.getString("KatılımTarihi");
         jTextField5.setText((rs.getString("KatılımTarihi")).trim());




         }         


        }catch(Exception e){
        JOptionPane.showMessageDialog(null, e);



        }






    }          

解决方案

this is not the way for inserting pst.execute(); use this way

pst.executeUpdate();

这篇关于java.sql.SQLException：数据库锁定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！