UC知道关于jsp页面的跳转问题 servlet不实现跳转 数据库MySQL测试没问题 下面是代码
来源：百度知道 编辑：UC知道 时间：2024/06/03 13:21:09
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.net.*;
import java.sql.*;
public class denglu extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1 = DriverManager.getConnection("jdbc:odbc:yjpx","root","");
Statement stmt1 = con1.createStatement();
String username = null;
String password = null;
String name = null;
String pass = null;
if(request.getParameter("guanliyuan")!=null)
{
PrintWriter out=response.getWriter();
out.println("<html><body><h1>This is a servlet test.</h1></body></html>");
out.flush();
username = reques
import javax.servlet.*;
import javax.servlet.http.*;
import java.net.*;
import java.sql.*;
public class denglu extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1 = DriverManager.getConnection("jdbc:odbc:yjpx","root","");
Statement stmt1 = con1.createStatement();
String username = null;
String password = null;
String name = null;
String pass = null;
if(request.getParameter("guanliyuan")!=null)
{
PrintWriter out=response.getWriter();
out.println("<html><body><h1>This is a servlet test.</h1></body></html>");
out.flush();
username = reques
SELECT * FROM yjpx.`user` u;"你的这个sql我没看明白，你是要登陆验证是吗？
那你这么写不更好吗？
PreparedStatement stat =null;
ResultSet reset = null;
String sql = "select * from tableName where name=? and pass = ?"
try{
stat = conn.prepareStatement(sql);
stat.setString(1,username);
stat.setString(2,password);
reset = stat.executeQuery();
boolean ok = false;
while(reset.next()){
ok= true;
}
reset.close();
stat.close();
}catch (SQLException e) {
throw new RuntimeException(e);
} finally {
conn.close();
}
if(ok){
response.sendRedirect("url1");
}else{
response.sendRedirect("url2");
}
你不关闭的话，以后肯定服务器受不了