package com.ajax.service; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.lang.ClassNotFoundException; import java.lang.String; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class _RService { public String message = null; Connection connection = null; public String doLogin(String username, String email, HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException, Exception { // load the sqlite-JDBC driver using the current class loader Class.forName("org.sqlite.JDBC"); String dbpath = request.getSession().getServletContext().getRealPath("/files/database/database.db"); try { connection = DriverManager.getConnection("jdbc:sqlite:"); Statement statement = connection.createStatement(); statement.executeUpdate("restore from "+dbpath); ResultSet rsu = statement.executeQuery("SELECT * FROM user WHERE user MATCH '" + username + "'"); ResultSet rse = statement.executeQuery("SELECT * FROM user WHERE user MATCH '" + email + "'"); //statement.executeQuery("insert into user values('" + username + "', '" + email + "', 'kjh', 'hjbj', 'gjhfhgxc', 'fzuguzg', 'fzuguzg', 'fzuguzg', 'fzuguzg', 'fzuguzg7', 'fzuguzg', 'fzu@guzg.net', 'fzuguzg', false, 'fzuguzg', 'fzuguzg')"); statement.executeUpdate("INSERT INTO USER VALUES('zzz','zzz','_Andy','_Admin','Street','45','66740','Saarlouis','Germany','+49683159899876','+491763159899876','+49683159899876','demo@demo.net',true,'Administrator','FFFFFFFFFF')"); Statement stat = connection.createStatement(); stat.executeUpdate("backup to "+dbpath); if(connection != null) connection.close(); } catch (Exception e) { //message = "FAILURE"; message = e.toString(); // e.printStackTrace(); } return message; } } |