package org.apache.jsp;import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.ResultSet;
import user.user_operation;
import java.sql.SQLException;public final class checkLogin_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent { private static final JspFactory _jspxFactory = JspFactory.getDefaultFactory(); private static java.util.List _jspx_dependants; private javax.el.ExpressionFactory _el_expressionfactory;
private org.apache.AnnotationProcessor _jsp_annotationprocessor; public Object getDependants() {
return _jspx_dependants;
} public void _jspInit() {
_el_expressionfactory = _jspxFactory.getJspApplicationContext(getServletConfig().getServletContext()).getExpressionFactory();
_jsp_annotationprocessor = (org.apache.AnnotationProcessor) getServletConfig().getServletContext().getAttribute(org.apache.AnnotationProcessor.class.getName());
} public void _jspDestroy() {
} public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException { PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
response.setContentType("text/html;charset=GB2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out; out.write("\r\n");
out.write("\r\n");
//-------接收输入参数------------
int sysuser_role=0;
ResultSet rs=null;
try{
sysuser_role=Integer.parseInt(request.getParameter("sysuser_role"));
}catch(Exception e){}
String sysuser_password=request.getParameter("sysuser_password");
String sysuser_name=request.getParameter("sysuser_name");
String certCode=request.getParameter("certCode");
//------查询数据库------
user_operation uop=new user_operation();
rs=uop.getUserOne(sysuser_name,sysuser_password,sysuser_role);
int rowCount=0;
try{
rs.next();
rowCount=1;
}catch(SQLException e){} if(rowCount!=0&&certCode.equals((String)session.getAttribute("certCode"))){
//------通过检查------
session.setAttribute("sysuser_id",rs.getString("sysuser_id"));
response.sendRedirect("./index.jsp");
}else{
response.sendRedirect("./login.jsp");
} out.write('\r');
out.write('\n');
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try { out.clearBuffer(); } catch (java.io.IOException e) {}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
红的字体中出现空指针异常,麻烦各位大哥大姐看一下,如何解决???谢谢了!!
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.ResultSet;
import user.user_operation;
import java.sql.SQLException;public final class checkLogin_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent { private static final JspFactory _jspxFactory = JspFactory.getDefaultFactory(); private static java.util.List _jspx_dependants; private javax.el.ExpressionFactory _el_expressionfactory;
private org.apache.AnnotationProcessor _jsp_annotationprocessor; public Object getDependants() {
return _jspx_dependants;
} public void _jspInit() {
_el_expressionfactory = _jspxFactory.getJspApplicationContext(getServletConfig().getServletContext()).getExpressionFactory();
_jsp_annotationprocessor = (org.apache.AnnotationProcessor) getServletConfig().getServletContext().getAttribute(org.apache.AnnotationProcessor.class.getName());
} public void _jspDestroy() {
} public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException { PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
response.setContentType("text/html;charset=GB2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out; out.write("\r\n");
out.write("\r\n");
//-------接收输入参数------------
int sysuser_role=0;
ResultSet rs=null;
try{
sysuser_role=Integer.parseInt(request.getParameter("sysuser_role"));
}catch(Exception e){}
String sysuser_password=request.getParameter("sysuser_password");
String sysuser_name=request.getParameter("sysuser_name");
String certCode=request.getParameter("certCode");
//------查询数据库------
user_operation uop=new user_operation();
rs=uop.getUserOne(sysuser_name,sysuser_password,sysuser_role);
int rowCount=0;
try{
rs.next();
rowCount=1;
}catch(SQLException e){} if(rowCount!=0&&certCode.equals((String)session.getAttribute("certCode"))){
//------通过检查------
session.setAttribute("sysuser_id",rs.getString("sysuser_id"));
response.sendRedirect("./index.jsp");
}else{
response.sendRedirect("./login.jsp");
} out.write('\r');
out.write('\n');
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try { out.clearBuffer(); } catch (java.io.IOException e) {}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
红的字体中出现空指针异常,麻烦各位大哥大姐看一下,如何解决???谢谢了!!
rowCount=1;
改成这个if(rs.next()) rowCount=1;
package user;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import util.stringUtil;
import db.dbconn;
public class user_operation {
public int isAutoGenOK(long foreign_id,int sysuser_role){
if(foreign_id==0||sysuser_role==0||sysuser_role==1||sysuser_role==2)
return 3;
String sqlString=null;//SQL语句字符串
ResultSet rs=null;//结果记录集
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null) return 3;//连接失败
sqlString="select * from sysuser where foreign_id=? and sysuser_role=?";
try{
PreparedStatement preSQLSelect=dbconn.prepareStatement(sqlString);
preSQLSelect.setLong(1,foreign_id);
preSQLSelect.setInt(2,sysuser_role);
rs=preSQLSelect.executeQuery();
if(rs.next()) return 1;
else return 0;
}catch(Exception e){
System.out.print(e);
return 3;
}
}
public int isAdminGenOK(long foreign_id,int sysuser_role){
if(foreign_id==0||sysuser_role==0)
return 3;
String sqlString=null;//SQL语句字符串
ResultSet rs=null;//结果记录集
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null) return 3;//连接失败
sqlString="select * from sysuser where foreign_id=? and sysuser_role=?";
try{
PreparedStatement preSQLSelect=dbconn.prepareStatement(sqlString);
preSQLSelect.setLong(1,foreign_id);
preSQLSelect.setInt(2,sysuser_role);
rs=preSQLSelect.executeQuery();
if(rs.next()) return 1;
else return 0;
}catch(Exception e){
System.out.print(e);
return 3;
}
}
public String genTeacherUser(String teacher_id[]){
String returnString=new String("");
String sqlString=null;//SQL语句字符串
ResultSet rs=null;//结果记录集
ResultSet rs1=null;//另一结果记录集
Statement sql=null;//SQL语句对象
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null) return returnString;//连接失败
try{
sqlString="select * from teacher";
System.out.println(teacher_id.length);
int j=0;//加长SQL语句的次数
if(teacher_id.length!=0){//生成部分教师用户
for(int i=0;i<teacher_id.length;i++)
if(teacher_id[i]!=null&&teacher_id[i].length()!=0&&!teacher_id[i].equalsIgnoreCase("null")){
if(j==0)
{sqlString=sqlString+" where teacher_id="+teacher_id[i];j++;}
else
sqlString=sqlString+" or teacher_id="+teacher_id[i];
}
}
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
while(rs.next()){
sqlString="select * from sysuser where foreign_id=" +
rs.getLong("teacher_id")+" and sysuser_role=3";
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs1=sql.executeQuery(sqlString);
if(!rs1.next()){//不存在插入,存在则不做事
sqlString="insert into sysuser(sysuser_name,sysuser_password,sysuser_role" +
",foreign_id) values(?,?,3,?)";
PreparedStatement preSQLUpdate=dbconn.prepareStatement(sqlString);
preSQLUpdate.setString(1,rs.getString("teacher_name"));
preSQLUpdate.setString(2,"111111");
preSQLUpdate.setLong(3,rs.getLong("teacher_id"));
preSQLUpdate.executeUpdate();
returnString=returnString+"生成教师"+rs.getString("teacher_name")+"用户成功!<BR>";
}else
returnString=returnString+"教师"+rs.getString("teacher_name")+"用户已经生成,不必再生成!<BR>";
rs1.close();
}
}catch(Exception e){
System.out.print(e);
}
return returnString;
}
public String genStudentUser(String student_id[]){
String returnString=new String("");
String sqlString=null;//SQL语句字符串
ResultSet rs=null;//结果记录集
ResultSet rs1=null;//另一结果记录集
Statement sql=null;//SQL语句对象
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null) return returnString;//连接失败
try{
sqlString="select * from student";
System.out.println(student_id.length);
int j=0;//加长SQL语句的次数
if(student_id.length!=0){//生成部分教师用户
for(int i=0;i<student_id.length;i++)
if(student_id[i]!=null&&student_id[i].length()!=0&&!student_id[i].equalsIgnoreCase("null")){
if(j==0)
{sqlString=sqlString+" where student_id="+student_id[i];j++;}
else
sqlString=sqlString+" or student_id="+student_id[i];
}
}
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
while(rs.next()){
sqlString="select * from sysuser where foreign_id=" +
rs.getLong("student_id")+" and sysuser_role=4";
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs1=sql.executeQuery(sqlString);
if(!rs1.next()){//不存在插入,存在则不做事
sqlString="insert into sysuser(sysuser_name,sysuser_password,sysuser_role" +
",foreign_id) values(?,?,4,?)";
PreparedStatement preSQLUpdate=dbconn.prepareStatement(sqlString);
preSQLUpdate.setString(1,rs.getString("student_name"));
preSQLUpdate.setString(2,"111111");
preSQLUpdate.setLong(3,rs.getLong("student_id"));
preSQLUpdate.executeUpdate();
returnString=returnString+"生成学生"+rs.getString("student_name")+"用户成功!<BR>";
}else
returnString=returnString+"学生"+rs.getString("student_name")+"用户已经生成,不必再生成!<BR>";
rs1.close();
}
}catch(Exception e){
System.out.print(e);
}
return returnString;
}
* 得到管理用户记录集,系统管理员和教务管理员是管理用户
*/
public ResultSet getAdminUsers(){
String sqlString=null;//SQL语句字符串
Statement sql=null;//SQL语句对象
ResultSet rs=null;//结果记录集
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null) return null;//连接失败
try{
//-------查询出数据------------
sqlString="select * from sysuser where sysuser_role=1 or sysuser_role=2";
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
return rs;
}catch(Exception e){
System.out.print(e);
return null;
}
}
public String genAdminUser(int teacher_id,int role_id){
String returnString=new String("");
String sqlString=null;//SQL语句字符串
ResultSet rs=null;//结果记录集
ResultSet rs1=null;//另一结果记录集
Statement sql=null;//SQL语句对象
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null||teacher_id==0||role_id==0) return returnString;//连接失败
try{
sqlString="select * from teacher where teacher_id="+teacher_id;
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
while(rs.next()){
sqlString="select * from sysuser where foreign_id=" +
rs.getLong("teacher_id")+" and sysuser_role="+role_id;
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs1=sql.executeQuery(sqlString);
if(!rs1.next()){//不存在插入,存在则不做事
sqlString="insert into sysuser(sysuser_name,sysuser_password,sysuser_role" +
",foreign_id) values(?,?,"+role_id+",?)";
System.out.println(sqlString);
PreparedStatement preSQLUpdate=dbconn.prepareStatement(sqlString);
preSQLUpdate.setString(1,rs.getString("teacher_name"));
preSQLUpdate.setString(2,"111111");
preSQLUpdate.setLong(3,rs.getLong("teacher_id"));
preSQLUpdate.executeUpdate();
returnString=returnString+"生成管理用户"+rs.getString("teacher_name")+"用户成功!<BR>";
}else
returnString=returnString+rs.getString("teacher_name")+"管理用户已经生成,不必再生成!<BR>";
rs1.close();
}
}catch(Exception e){
System.out.print(e);
}
return returnString;
}
public ResultSet getUserByPrimKey(int sysuser_id){
String sqlString=null;//SQL语句字符串
Statement sql=null;//SQL语句对象
ResultSet rs=null;//结果记录集
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null||sysuser_id==0) return null;//连接失败
try{
//-------查询出数据------------
sqlString="select * from sysuser where sysuser_id="+sysuser_id;
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
return rs;
}catch(Exception e){
System.out.print(e);
return null;
}
}
public long getUserId(int foreign_id,int sysuser_role){
if(foreign_id==0||sysuser_role==0) return 0;
String sqlString=null;//SQL语句字符串
Statement sql=null;//SQL语句对象
ResultSet rs=null;//结果记录集
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null) return 0;//连接失败
try{
//-------查询出数据------------
sqlString="select * from sysuser where foreign_id="+foreign_id+
" and sysuser_role="+sysuser_role;
//System.out.println(sqlString);
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
if(rs.next())
return rs.getLong("sysuser_id");
else
return 0;
}catch(Exception e){
e.printStackTrace();
return 0;
}
}
public int update_sysuser(int user_id,String user_name,String user_password,int user_role){
if(user_role==0||user_id==0) return 0;
String sqlString=null;//SQL语句字符串
Statement sql=null;//SQL语句对象
ResultSet rs=null;//结果记录集
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
//--------输入参数编码转换-------
stringUtil stringCode=new stringUtil();
user_name=stringCode.codeToString(user_name.trim());
user_password=stringCode.codeToString(user_password.trim());
if(dbconn==null) return 0;//连接失败
try{
//-------查询出数据------------
sqlString="update sysuser set sysuser_name='" + user_name +
"',sysuser_password='"+user_password+"',sysuser_role="+
user_role+" where sysuser_id="+user_id;
//System.out.println(sqlString);
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
return sql.executeUpdate(sqlString);
}catch(Exception e){
e.printStackTrace();
return 0;
}
}
public int deleteUserByPrimKey(int sysuser_id){
String sqlString=null;//SQL语句字符串
Statement sql=null;//SQL语句对象
ResultSet rs=null;//结果记录集
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null||sysuser_id==0) return 0;//连接失败
try{
//-------查询出数据------------
sqlString="delete from sysuser where sysuser_id="+sysuser_id;
sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
return sql.executeUpdate(sqlString);
}catch(Exception e){
System.out.print(e);
return 0;
}
}
public ResultSet getUserOne(String sysuser_name,String sysuser_password,int sysuser_role){
String sqlString=null;//SQL语句字符串
Statement sql=null;//SQL语句对象
ResultSet rs=null;//结果记录集
dbconn dbconnOBject=new dbconn();//数据库连接对象
Connection dbconn=dbconnOBject.getDBConn();//得到数据库连接
if(dbconn==null) return null;//连接失败
//--------输入参数编码转换-------
stringUtil stringCode=new stringUtil();
sysuser_name=stringCode.codeToString(sysuser_name.trim());
sysuser_password=stringCode.codeToString(sysuser_password.trim());
try{
//-------查询出数据------------
sqlString="select * from sysuser where sysuser_name=? and sysuser_password=? and sysuser_role=?";
PreparedStatement preSQLSelect=dbconn.prepareStatement(sqlString);
preSQLSelect.setString(1,sysuser_name);
preSQLSelect.setString(2,sysuser_password);
preSQLSelect.setInt(3,sysuser_role);
rs=preSQLSelect.executeQuery();
System.out.println("select * from sysuser where sysuser_name='"+sysuser_name+"' and sysuser_password='"+ sysuser_password+"' and sysuser_role="+sysuser_role);
return rs;
}catch(Exception e){
System.out.print(e);
return null;
}
}
}