1、headmeta http-equiv=Content-Type content=titleInsert title here/head Hello!/html附:修改默认字符集步骤:Windows-Preference-Web-JSPfiles-将Encoding改为UTF-82) 右击项目-Properties-Resurce-修改字符集为UTF-8.3) 右击项目-Java Build Path改为如图(需先在WEB-INF下新建classes)4) 将MySQL中一个jar包复制到/WEB-INF/lib下,如图:3、 在/WebContent下new一个JSPfile,名字为disp
2、lay0.jsp代码如下:UTF-8 % page import=java.sql.* /(注意要引入sql的包)% String connStr = jdbc:mysql:/localhost:3306/yStudent?characterEncoding=utf8; Connection conn = null; Statement stmt = null; ResultSet rs; try Class.forName(com.mysql.jdbc.Driver); conn = DriverManager.getConnection(connStr, root, 123456 stmt
3、 = conn.createStatement(); catch (Exception ex) ex.printStackTrace(); System.out.println(exception in getConnection String sql = select * from studentinfo /表明为studentinfo rs = stmt.executeQuery(sql); trth编号姓名年龄% while (rs.next() % %= rs.getString(id)%/tdname%= rs.getInt(age) % %/table% stmt.close();
4、 conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); %4、 在项目下新建一个文件夹DataBase,将用到的学生数据库脚本文件复制到此目录下5、 启动mysql,Tomcat,运行测试display0.6、 改进版本display11)将display0.jsp复制粘贴到本项目的/WebCont下并修改命名为display1.jsp2)在/src下new一个新包,包名为com.ls.student.bean 并在此包下新建两个新类来处理SQL的Helper。SQ
5、LHelper.java代码如下:package com.ls.student.bean;import java.sql.*; /引入sql相关包public class SQLHelper private String driverStr = private String connStr = private String dbusername = private String dbpassword = private Connection conn = null; private Statement stmt = null; public SQLHelper() try Class.forN
6、ame(driverStr); conn = DriverManager.getConnection(connStr, dbusername, dbpassword); stmt = conn.createStatement(); catch (Exception ex) System.out.println(exception in SQLHelper public int executeUpdate(String sql) int result = 0; result = stmt.executeUpdate(sql);Exception in executeUpdate return r
7、esult; public ResultSet executeQuery(String sql) ResultSet rs = null; rs = stmt.executeQuery(sql); if(!rs.next() return null; rs.previous();Exception in executeQuery return rs; public void close() stmt.close(); conn.close(); catch (Exception e) 在此包下新建student类,代码如下public class student private String
8、id,name; private int age; public student() super(); public student(String id, String name, int age) this.id = id; this.name = name; this.age = age; public String getId() return id; public void setId(String id) public String getName() return name; public void setName(String name) public int getAge()
9、return age; public void setAge(int age) Override public String toString() return Student id= + id + , name= + name + , age= + age + 3)display1.jsp代码修改如下:注意先引入java.sql.*包和com.ls.student.bean包主要代码修改为内的修改,代码如下:java.sql.*;import com.ls.student.bean.* /引入包 SQLHelper db= new SQLHelper(); String sql = Resu
10、ltSet rs = db.executeQuery(sql);操作 a href=update.jsp?id=修改 &delete.jsp? 删除 % db.close();7、 实现增加功能新建insert.jsp文件Insert student0) out.println(添加记录成功! else out.println(添加记录失败! stmt.close(); conn.close();以及插入的html显示页面,代码:div align=centerh2strong请输入学生信息/h2form method=post action=insert.jsptable width=200 border=0 align=学号submit value=提交td align=reset重置/form9、删除实现,delete.jspdelete studentdelete from studentinfo where id=删除记录成功!删除 记录失败!10、查找query.jspquery result=+ minAge;maxAge.isEmpty() and age编号 年龄 %=rs.getInt(% rs.close();stmt.close();conn.close();Query的html页面:DOCT
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1