助学贷款管理系统JSP版

在使用该系统之前，你要安装MYSQL5.0， eclipse6.0，tomcat5.5，JDK1.5或以上版本，且按照下面的SQL语句建库建表，！ 本系统还有个问题没解决，就是用户那个表读出来的中文都是乱码，我用了过滤器处理乱码的但还是有问题， 希望用这个系统的仁兄解决这个问题，方便的话请指教我下，怎么解决的，本人将不胜感激！ 我的QQ是454195091.本系统做的不好，还望各位赐教，谢谢！ create database studentLoan; use studentLoan; create table user(uid varchar(50) not null primary key,username varchar(50) not null,password varchar(50) not null, status SMALLINT,state SMALLINT,index index_user (uid)); create table student(number varchar(50) not null primary key,name varchar(50) not null, sex varchar(10) check(sex in ('男','女')),birthday varchar(50) not null,enterSchoolTime varchar(50) not null, academy varchar(50) not null, class varchar(50) not null,major varchar(50) not null,address varchar(50), telNumber varchar(50),postID varchar(50),familyTel varchar(50),index index_student (number)); create table loan(loanID varchar(50) not null primary key,name varchar(50) not null,number varchar(50) not null, applyLoanTime varchar(50),loanType SMALLINT ,loanAmount int,loanState varchar(50) not null, index index_loan (loanID,number)); create table guestboard(gid int auto_increment not null primary key,title varchar(50),guest varchar(50), gtime datetime,content varchar(200),gflag SMALLINT default 0,rtime datetime,recontent text); create table affiche(aid int auto_increment not null primary key,uid varchar(50),title varchar(200),atime datetime, content text,index index_affiche (uid)); create table link(lid int auto_increment not null primary key,name varchar(50),ltime datetime, url varchar(50)); create table news(nid int auto_increment not null primary key,uid varchar(50),title varchar(200),ntime datetime, fromto varchar(100),content text,type int,index index_news (uid)); alter table student add FOREIGN KEY (number) REFERENCES user(uid); alter table loan add FOREIGN KEY (number) REFERENCES student(number); alter table affiche add FOREIGN KEY (uid) REFERENCES user(uid); alter table news add FOREIGN KEY (uid) REFERENCES user(uid); insert into user values("063823016","杨德伟","454195091",1,0); insert into user values("063823017","小王","454195091",0,0); insert into user values("063823015","小阳","454195091",0,0); insert into user values("063823014","小陈","454195091",0,0); insert into user values("063823013","小田","454195091",0,0); insert into user values("063823018","小张","454195091",2,0); insert into user values("063823019","小李","454195091",3,0); insert into user values("063823020","小杨","454195091",4,0);