个人信息管理系统源代码(自己写的)

1、这是一个个人信息管理系统的web应用程序，为本人学习完JSP后花了一天时间写的，虽然很粗糙，但因为所学知识不多，编程经验很少，能做到这样，觉得暂时还不错。数据库为sqlserver2005开发环境为eclipse以下是源代码。包括数据库的创建,B.java(JavaBeans放翁数据库),index.jsp(主页)和Jsp0.jsp,Jsp1.jsp, Jsp2.jsp, Jsp3.jsp, Jsp4.jsp, Jsp5.jsp, Jsp6.jsp, 创建数据库create database quanon primary(name=quan_db,filename=d:quan.mdf,siz

2、e=5mb,maxsize=50mb,filegrowth=10%)create table m(mid char(30) not null primary key,mname char(10) not null,sex char(8),age int,height int,jianshu char(50),aihao char(50)-/bean访问数据库/bean访问数据库package b;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import ja

3、va.sql.ResultSet;import java.sql.SQLException;public class B private String name;private String mid;private String sex;private int age;private int height;private String jianshu;private String aihao;public void B()name=;mid=;sex=;age=0;height=0;jianshu=;aihao=;public void setName(String name)this.nam

4、e=name;public String getName()return name;public void setMid(String mid)this.mid=mid;public String getMid()return mid;public void setSex(String sex)this.sex=sex;public String getSex()return sex;public void setAge(int age)this.age=age;public int getAge()return age;public void setHeight(int height)thi

5、s.height=height;public float getHeight()return height;public void setJianshu(String jianshu)this.jianshu=jianshu;public String getJianshu()return jianshu;public void setAihao(String aihao)this.aihao=aihao;public String getAihao()return aihao;static try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); ca

6、tch (ClassNotFoundException e) / TODO Auto-generated catch blocke.printStackTrace();Connection getCon(String user,String pwd)Connection con=null;try con=DriverManager.getConnection(jdbc:odbc:qdb,user,pwd); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallyif(con=null

7、)return null;elsereturn con;void close1(Connection con,PreparedStatement ps)try if(con!=null)con.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry if(ps!=null)ps.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();void cl

8、ose2(Connection con,PreparedStatement ps,ResultSet rs)try if(con!=null)con.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry if(ps!=null)ps.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry if(rs!=null)rs.clo

9、se(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();/从数据库读取个人信息public boolean r(String mid)/一mid作为查询条件Connection con=null;PreparedStatement ps=null;ResultSet rs=null;try con=getCon(sa,quan1989);String sql=select *from m where mid=?;ps=con.prepareStatement(sql);ps.setStr

10、ing(1, mid);rs=ps.executeQuery();if(rs.next()this.mid=rs.getString(mid);=rs.getString(mname);this.sex=rs.getString(sex);this.age=rs.getInt(age);this.height=rs.getInt(height);this.jianshu=rs.getString(jianshu);this.aihao=rs.getString(aihao);return true;return false; catch (SQLException e) /

11、TODO Auto-generated catch blocke.printStackTrace();return false;finallyclose2(con,ps,rs);/写入个人信息到数据库public void w()Connection con=null;PreparedStatement ps=null;try con=getCon(sa,quan1989);String sql=insert into m values(?,?,?,?,?,?,?);ps=con.prepareStatement(sql);ps.setString(1,mid);ps.setString(2,

12、 name);ps.setString(3,sex);ps.setInt(4,age);ps.setInt(5,height);ps.setString(6,jianshu);ps.setString(7,aihao);ps.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallyclose1(con,ps);/修改个人信息public boolean update(String mid)Connection con=null;PreparedStat

13、ement ps=null;try con=getCon(sa,quan1989);String sql=update m set mname=?,sex=?,age=?,height=?,jianshu=?,aihao=? where mid=? ;ps=con.prepareStatement(sql);ps.setString(1,name );ps.setString(2,sex );ps.setInt(3,age );ps.setInt(4,height );ps.setString(5,jianshu );ps.setString(6,aihao );ps.setString(7,

14、mid );ps.executeUpdate();return true; catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return false;finallyclose1(con,ps);/暂空public boolean delete(String mid)Connection con=null;PreparedStatement ps=null;try con=getCon(sa,quan1989);String sql=delete from m where mid=?;ps=c

15、on.prepareStatement(sql);ps.setString(1,mid );ps.executeUpdate();return true; catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return false;finallyclose1(con,ps);-index.jsp base href= 个人信息主页 !- 欢迎 登记个人信息查询修改删除个人信息 -Jsp0.jsp base href= 登记页 !- function f()if(document.form1.n

16、ame.value.length=0)alert(名字不能为空);return false;if(document.form1.mid.value.length!=15&document.form1.mid.value.length!=18)alert(身份证长度错误);return false; 姓名身份证号码性别男女年龄身高个人爱好个人简述 返回主页 -Jsp1.jsp base href= 登记数据处理 !- %int age; int height;String name=request.getParameter(name);byte b=name.getBytes(ISO-8859-

17、1);name=new String(b);String mid=request.getParameter(mid);b=mid.getBytes(ISO-8859-1);mid=new String(b);String sex=request.getParameter(sex);if(sex=null)sex=;elseb=sex.getBytes(ISO-8859-1);sex=new String(b);String hstring=request.getParameter(height);if(hstring.equals()height=0;elseb=hstring.getByte

18、s(ISO-8859-1);hstring=new String(b);height=Integer.parseInt(hstring);String agestring=request.getParameter(age);if(agestring.equals()age=0;elseb=agestring.getBytes(ISO-8859-1);agestring=new String(b);age=Integer.parseInt(agestring);String jianshu=request.getParameter(jianshu);if(jianshu=null)jianshu

19、=;elseb=jianshu.getBytes(ISO-8859-1);jianshu=new String(b); String aihao=request.getParameter(aihao); if(aihao=null)aihao=;elseb=aihao.getBytes(ISO-8859-1);aihao=new String(b);if(dao1.r(mid)out.println(您已登记);elsedao1.setName(name);dao1.setMid(mid);dao1.setSex(sex);dao1.setAge(age);dao1.setHeight(hei

20、ght);dao1.setJianshu(jianshu);dao1.setAihao(aihao);/写入数据库dao1.w();out.println(提交成功);/out.println(dao1.show();%返回主页 -Jsp2.jsp base href= 查询页 !- function f()if(document.form1.mid.value.length!=15&document.form1.mid.value.length!=18)alert(身份证长度错误);return false;输入要查询或修改身份证号码返回主页 -Jsp3.jsp base href= 查询处

21、理 !- 查询结果姓名身份证号码性别年龄身高个人爱好个人简述input type=hidden name=hidden value=input type=hidden name=hidden value=返回主页 -Jsp4.jsp base href= My JSP Jsp4.jsp starting page !- % String mid=request.getParameter(hidden); byte b=mid.getBytes(ISO-8859-1); mid=new String(b); out.println(您的身份证号码是：+mid+); out.println(请填写以下的修改信息:); %function f()if(document.form1.mid.value.length=0)alert(姓名长度不能为空);return false;input type=hidden name=hidden value=姓名性别男女年龄身高个人爱好个人简述返回主页 -Jsp5.jsp base href= 修改页 !- %int age; int h