简单的学生信息管理系统

来源：网络收集时间：2026-07-22

导读： jsp中简单的学生管理系统,可以基本实现对数据库的增删查改 //连接数据库方法类 JDBCConnection.java packagegj; importjava.sql.Connection; importjava.sql.DriverManager; importjava.sql.SQLException; public class JDBCConnection { String driverName

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

//连接数据库方法类

JDBCConnection.java

packagegj;

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.SQLException;

public class JDBCConnection {

String driverName = "com.mysql.jdbc.Driver"; //驱动程序名

String userName = "root"; //数据库用户名

String userPwd = "text"; //密码

String dbName = "user"; //数据库名

String tableName = "user_list3"; //数据表名

String url ="";

public String getDriverName() {

returndriverName;

}

public void setDriverName(String driverName) {

this.driverName = driverName;

}

public String getUserName() {

returnuserName;

}

public void setUserName(String userName) {

erName = userName;

}

public String getUserPwd() {

returnuserPwd;

}

public void setUserPwd(String userPwd) {

erPwd = userPwd;

}

public String getDbName() {

returndbName;

}

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

public void setDbName(String dbName) {

this.dbName = dbName;

}

public String getTableName() {

returntableName;

}

public void setTableName(String tableName) {

this.tableName = tableName;

}

public String getUrl() {

returnurl;

}

public void setUrl(String url) {

this.url = url;

}

//实现数据库连接的方法

public Connection getConnection() throws SQLException,

ClassNotFoundException { //实现数据库连接的方法

String url1="jdbc:mysql://localhost:3306/"+dbName;

String url2 ="?user="+userName+"&password="+userPwd;

String url3="&useUnicode=true&characterEncoding=GB2312";

url =url1+url2+url3;

Class.forName(driverName);

returnDriverManager.getConnection(url);

}

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

//用户登录界面

Index.jsp

<head>

{

varuserName=document.forms["form1"].UserName.value;

varpassword=document.forms["form1"].pd.value;

if(userName.length<=0)

{

alert("用户名不能为空！");

}

else if(password<=0)

{

alert("密码不能为空！");

}

else

{

document.forms["form1"].submit();

}

</script>

</head>

<title>My JSP 'index.jsp' starting page</title> <script type="text/javascript"> functionvalidate()

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

<br>

<form action="CheckShow" name="form1" method="post"> <table width="248" height="106" border="0"> <tr> <td> 用户名： </td> <td> <input type="text" name="UserName" /> </td> </tr> <tr> <td> 密 码： </td> <td> <input type="password" name="pd" /> </td> </tr> <tr> <td colspan="2">         <input

type="button" value="登录" onclick="validate()" onmousemove="hand">

</tr> </table> </form> <p><%=request.getAttribute("return")%></p> <p align="left"><% int count = 0; if (application.getAttribute("count") == null) { count += 1;

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

} count = Integer.parseInt(application.getAttribute("count") .toString()); count += 1; application.setAttribute("count", count); } else {

out.print("您是本系统的第"+count+"位访问者!");

%></p>

</div>

</body>

</html>

//用户登录后台验证类

CheckLogin.java

packagegj;

importjava.sql.Connection;

importjava.sql.ResultSet;

importjava.sql.SQLException;

importjava.sql.Statement;

public class CheckLogin {

private String name;

private String password;

public String getName() {

return name;

}

public void setName(String name) {

= name;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

publicCheckLogin(String name, String password) {

super();

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

= name;

this.password = password;

}

publicint Check() throws SQLException, ClassNotFoundException {

JDBCConnectionkkk = new JDBCConnection();

Connection con = kkk.getConnection();

Statement statement;

try {

statement = con.createStatement();

String sql = "select * from user_list3 where name='" + name + "' …… 此处隐藏：3032字，全部文档内容请下载后查看。喜欢就下载吧 ……

简单的学生信息管理系统.doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印

下载这篇word文档

本文链接：https://www.jiaowen.net/wenku/127391.html（转载请注明文章来源）

上一篇：学校安全工作述职报告
下一篇：住宅楼(混合)施工组织设计