Jest problem. Kod poniżej
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.dawid.models.PageModel;
import org.dawid.pojo.Page;
/**
* Servlet implementation class System
*/
@WebServlet("/System")
public class System extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public System() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection connection = Connector.getConnection();
String select = "SELECT * FROM pages WHERE uid = ?";
try {
PreparedStatement selectQuery = connection.prepareStatement(select);
selectQuery.setInt(1, 1);
ResultSet result = selectQuery.executeQuery();
result.first();
} catch(SQLException sqlex) {}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
private static class Connector {
public static Connection getConnection() {
Connection connect = null;
try {
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost/welcomeweb?user=user&password=pass");
} catch(ClassNotFoundException cnfe) {
// System.out.println("brak klasy");
} catch(SQLException sqle) {
// System.out.println("brak polaczenia");
}
return connect;
}
}
}
PreparedStatement selectQuery = connection.prepareStatement(select); <-- na tej linii dostaje NullPointException. Wygląda jakby połączenie było nullem a nie jest. Nie rozumiem czemu tak się dzieje :/