<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>用结果集更新数据库中的表</title>
</head>
<body>
<%
Vector vector = new Vector();
Connection con;
Statement sql;
ResultSet rs;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
out.print("<b style='color:red'>ClassNotFoundException</>");
}
try {
String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
con = DriverManager.getConnection(url, "sa", "root");
sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs = sql.executeQuery("select * from students");
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th width='100'>学号");
out.print("<th width='100'>姓名");
out.print("<th width='50'>数学成绩");
out.print("<th width='50'>英语成绩");
out.print("<th width='50'>物理成绩");
out.print("</tr>");
//插入记录操作开始
rs.moveToInsertRow();//将数据表游标移到插入记录位置
rs.updateString("姓名", "赵刚");
rs.updateString("学号", "8888");
rs.updateInt(3, 66);
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>用结果集更新数据库中的表</title>
</head>
<body>
<%
Vector vector = new Vector();
Connection con;
Statement sql;
ResultSet rs;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
out.print("<b style='color:red'>ClassNotFoundException</>");
}
try {
String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
con = DriverManager.getConnection(url, "sa", "root");
sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs = sql.executeQuery("select * from students");
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th width='100'>学号");
out.print("<th width='100'>姓名");
out.print("<th width='50'>数学成绩");
out.print("<th width='50'>英语成绩");
out.print("<th width='50'>物理成绩");
out.print("</tr>");
//插入记录操作开始
rs.moveToInsertRow();//将数据表游标移到插入记录位置
rs.updateString("姓名", "赵刚");
rs.updateString("学号", "8888");
rs.updateInt(3, 66);