简单的学生信息管理系统.docx

《简单的学生信息管理系统.docx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、//连接数据库方法类JDBCConnection.javapackagegj;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;publicclassJDBCConnection{StringdriverName="com.mysql.jdbc.Driver";//驱动程序名StringuserName="root";//数据库用户名StringuserPwd="text";//密码StringdbName="user";//数据库名Strin

2、gtableName="user_list3";//数据表名Stringurl="";publicStringgetDriverName(){returndriverName;}publicvoidsetDriverName(StringdriverName){this.driverName=driverName;}publicStringgetUserName(){returnuserName;}publicvoidsetUserName(StringuserName){this.userName=userName;}publicStringgetUser

3、Pwd(){returnuserPwd;}publicvoidsetUserPwd(StringuserPwd){this.userPwd=userPwd;}publicStringgetDbName(){returndbName;}publicvoidsetDbName(StringdbName){this.dbName=dbName;}publicStringgetTableName(){returntableName;}publicvoidsetTableName(StringtableName){this.tableName=tableName;}p

4、ublicStringgetUrl(){returnurl;}publicvoidsetUrl(Stringurl){this.url=url;}//实现数据库连接的方法publicConnectiongetConnection()throwsSQLException,ClassNotFoundException{//实现数据库连接的方法Stringurl1="jdbc:mysql://localhost:3306/"+dbName;Stringurl2="?user="+userName+"&password="+userPwd;Stringurl3="&

5、useUnicode=true&characterEncoding=GB2312";url=url1+url2+url3;Class.forName(driverName);returnDriverManager.getConnection(url);}}//用户登录界面Index.jspfunctionvalidate(){varuserName=document.forms["form1"].Use

6、rName.value;varpassword=document.forms["form1"].pd.value;if(userName.length<=0){alert("用户名不能为空！");}elseif(password<=0){alert("密码不能为空！");}else{document.forms["form1"].submit();}}

用户登录