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;
}
}
|
На самом деле, есть техники кодирования, которые позволяют экономно выделять память, но это - отдельная большая тема.