Java

Member 11384820 wrote:

please help i cant do it!

Member 11110116 wrote:

how to fix it?

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import javax.swing.JOptionPane;
public class Sqliteconn {
    public static Statement sqliteStmt()
    {
        try{
            Class.forName("org.sqlite.JDBC");
            Connection conn = DriverManager.getConnection("jdbc:sqlite:B12MSqlite.sqlite");
            Statement  stmt=conn.createStatement();   
            return stmt;
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e);
            return null;
        }
    }
    
}

String query="Insert into Employee values('"+txtID.getText()+"','"+txtName.getText()+"','"+txtFName.getText()+"','"+txtEmail.getText()+"')";
try{
    Sqliteconn.sqliteStmt().execute(query);
}
catch(Exception e)
{
   JOptionPane.showMessageDialog(null, e);
}

String query="Insert into Employee values('"+txtID.getText()+"','"+txtName.getText()+"','"+txtFName.getText()+"','"+txtEmail.getText()+"')";
try{
    Sqliteconn.sqliteStmt().execute(query);
}

Member 12229369 wrote:

Is there a method of reducing the immense length of such a piece of code...