用NetBeans在写,使用microsoft.sqlserver,service里面已经显示连上数据库了,也可以进行修改,可是运行总是出错,到底是什么问题呢???已简化的servlet代码:package cs;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.naming.NamingException;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
/**
*
* @author 50915287
*/
public class register extends HttpServlet {
protected void doPost( HttpServletRequest request,
HttpServletResponse response )
throws ServletException, IOException
{
try {
reg(request, response);
} catch (SQLException ex) {
Logger.getLogger(register.class.getName()).log(Level.SEVERE, null, ex);
} catch (NamingException ex) {
Logger.getLogger(register.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void reg (HttpServletRequest request,
HttpServletResponse response )
throws IOException, SQLException, NamingException
{ String ID=request.getParameter("username");
String pd=request.getParameter("password");
String cpd=request.getParameter("cpassword");
String mail=request.getParameter("email");
Connection con;
javax.naming.Context initCtx = new javax.naming.InitialContext();
javax.naming.Context envCtx = (javax.naming.Context)initCtx.lookup("java:/comp/env");
javax.sql.DataSource ds = (javax.sql.DataSource)envCtx.lookup("jdbc/userInformation");
con = ds.getConnection();
PreparedStatement ps = con.prepareStatement("INSERT INTO [userInformation] VALUES('?','?','?')");
ps.setString(1,"ff"); --〉debug的时候到了这句就过不去了
ps.setString(2,"ff");
ps.setString(3,"ff.com");
ps.executeUpdate();
msg(request,response,"testing");
ps.close();
con.close();
}
private void msg (HttpServletRequest request,
HttpServletResponse response,String Meg)
throws IOException
{ response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.write("<head>");
out.write("<title>Failed</title>");
out.write("</head>");
out.write("<body>");
out.write("<center><h2>"+ Meg + "</h2><p><a href=\"regist.html\">Try again.</a></p></center>");
out.write(" </body>");
out.write("</html>");
}
各位大虾,到底问题出在哪里呢???orz
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.naming.NamingException;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
/**
*
* @author 50915287
*/
public class register extends HttpServlet {
protected void doPost( HttpServletRequest request,
HttpServletResponse response )
throws ServletException, IOException
{
try {
reg(request, response);
} catch (SQLException ex) {
Logger.getLogger(register.class.getName()).log(Level.SEVERE, null, ex);
} catch (NamingException ex) {
Logger.getLogger(register.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void reg (HttpServletRequest request,
HttpServletResponse response )
throws IOException, SQLException, NamingException
{ String ID=request.getParameter("username");
String pd=request.getParameter("password");
String cpd=request.getParameter("cpassword");
String mail=request.getParameter("email");
Connection con;
javax.naming.Context initCtx = new javax.naming.InitialContext();
javax.naming.Context envCtx = (javax.naming.Context)initCtx.lookup("java:/comp/env");
javax.sql.DataSource ds = (javax.sql.DataSource)envCtx.lookup("jdbc/userInformation");
con = ds.getConnection();
PreparedStatement ps = con.prepareStatement("INSERT INTO [userInformation] VALUES('?','?','?')");
ps.setString(1,"ff"); --〉debug的时候到了这句就过不去了
ps.setString(2,"ff");
ps.setString(3,"ff.com");
ps.executeUpdate();
msg(request,response,"testing");
ps.close();
con.close();
}
private void msg (HttpServletRequest request,
HttpServletResponse response,String Meg)
throws IOException
{ response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.write("<head>");
out.write("<title>Failed</title>");
out.write("</head>");
out.write("<body>");
out.write("<center><h2>"+ Meg + "</h2><p><a href=\"regist.html\">Try again.</a></p></center>");
out.write(" </body>");
out.write("</html>");
}
各位大虾,到底问题出在哪里呢???orz
应该是这样的吧 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ps.setString(0,"ff"); --〉debug的时候到了这句就过不去了
ps.setString(1,"ff");
ps.setString(2,"ff.com");