一个简单的java学生寝室查询系统

2023-09-22 20:15:26 54

本文实例为大家分享了java学生寝室查询系统的具体代码，供大家参考，具体内容如下

前端部分：

index.html





AHPUFreshmandormitoryinquiry







姓名




学号







双微工作室

confrim.js:

varEventUtil={
addhandler:function(element,type,handler){
if(element.addEventListener){
element.addEventListener(type,handler,false);
}elseif(element.attachEvent){
element.attachEvent("on"+type,handler);
}else{
element["on"+type]=handler;
}
},
removehandler:function(element,type,handler){
if(element.removeEventListener){
element.removeEventListener(type,handler,false);
}elseif(element.detachEvent){
element.detachEvent("on"+type,handler);
}else{
element["on"+type]=null;
}
},

getEvent:function(event){
returnevent?event:window.event;
},
getTarget:function(event){
returnevent.target||event.srcElement;
},
preventDefault:function(event){
if(event.preventDefault){
event.preventDefault();
}else{
event.returnValue=false;
}
},
stopPropagation:function(event){//只能阻止事件冒泡
if(event.stopPropagation){
event.stopPropagation();
}else{
event.cancelBubble=true;
}
}
};



functionconfirmName(){
if(((sname.value).trim).length!=0){
reg=/^[\u4e00-\u9fa5]{1,10}$/;
if(!reg.test(sname.value)){
sname.value="";
alert("请输入正确的姓名");
}
}
}


functionconfirmSid(){
if(((sid.value).trim()).length!=0){
reg=/^([0-9]){10,10}$/;
if(!reg.test(sid.value)){
sid.value="";
alert("请输入正确的学号");
}
}
}

functionconfirm(){
EventUtil.addhandler(sname,"blur",confirmName);
EventUtil.addhandler(sid,"blur",confirmSid);
}

window.onload=function(){
varsname=document.querySelector("#sname");
varsid=document.querySelector("#sid");
varpo=document.querySelector("#submit");
confirm();
EventUtil.addhandler(po,"submit",confrimName);
EventUtil.addhandler(po,"submit",confrimSid);
};

后端java部分：

packageFindRoom;

importjava.io.IOException;
importjava.io.PrintWriter;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;

//importjavax.servlet.RequestDispatcher;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;

publicclassfindInfoextendsHttpServlet{
staticfinalStringJDBC_DRIVER="com.mysql.jdbc.Driver";
staticfinalStringDB_URL="jdbc:mysql://localhost:3306/RoomQuery";
//数据库的用户名与密码，需要根据自己的设置
staticfinalStringUSER="root";
staticfinalStringPASS="cd7089028";
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
this.log("执行doGet方法....");
this.execute(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
this.log("执行doPost方法....");
this.execute(request,response);
}
//执行方法
publicvoidexecute(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
PrintWriterout=response.getWriter();
//StringBufferrequestURI=request.getRequestURL();
//Stringmethod=request.getMethod();
Stringsname=request.getParameter("sname");
Stringsid=request.getParameter("sid");
response.setContentType("text/html");
//RequestDispatcherdispatcher=request.getRequestDispatcher("/RoomQuery/findInfo");
Connectionconn=null;
Statementstmt=null;
try{
//注册JDBC驱动
Class.forName(JDBC_DRIVER);
//DriverManager.registerDriver(newcom.mysql.jdbc.Driver());
//打开链接
System.out.println("连接数据库...");
conn=DriverManager.getConnection(DB_URL,USER,PASS);
//执行查询
System.out.println("实例化Statement对...");
stmt=conn.createStatement();
Stringsql;
sql="SELECT*FROMSumRoidwhereSId="+sid;
ResultSetrs=stmt.executeQuery(sql);
//展开结果集数据库
while(rs.next()){
//通过字段检索
StringflatNum=rs.getString("FlatNum");
StringbedrootNum=rs.getString("BedroomNum");
Stringname=rs.getString("Sname");
StringSid=rs.getString("SId");
Stringssex=rs.getString("Ssex");
Stringacademy=rs.getString("academy");
Stringmajor=rs.getString("major");

//输出数据
out.println("");
out.println("AServlet");
out.println("");
out.println("");
out.println(""+sname+"同学欢迎你");
out.println("公寓号："+flatNum+""
+"寝室号:"+bedrootNum+""
+"姓名:"+name+""
+"学号:"+Sid+""
+"性别:"+ssex+""
+"学院:"+academy+""
+"专业:"+major+"");
}
out.println("");
out.println("");
//完成后关闭
rs.close();
stmt.close();
conn.close();
out.flush();
out.close();
}catch(SQLExceptionse){
//处理JDBC错误
se.printStackTrace();
}catch(Exceptione){
//处理Class.forName错误
e.printStackTrace();
}finally{
//关闭资源
try{
if(stmt!=null)stmt.close();
}catch(SQLExceptionse2){
}//什么都不做
try{
if(conn!=null)conn.close();
}catch(SQLExceptionse){
se.printStackTrace();
}
}
}

}

数据库mysql部分:

将excel中学生的信息存放在A盘的stu.txt文件中；

创建table:

createtableSumRoid(FlatNumchar(10),BedroomNumchar(3),Snamechar(10),SIdchar(15),Ssexchar(2),academychar(30),majorchar(20));

3.将数据读入mysql数据库中：

loaddatalocalinfile'A:/stu.txt'intotableSumRoid;

至此，一个超级简单的查询系统已完毕。

说明:

1.在做表单输入验证时，bug很多；
2.jdbc的驱动一定要导入web-inflib中；
3.web.xml配置一定要检查好；
4.不能预防sql注入；

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持毛票票。

一个简单的java学生寝室查询系统

"+sname+"同学欢迎你

热门推荐

随机推荐