<%@ page language="java" contentType="text/html; charset=GB2312"
pageEncoding="GB2312"%>
<!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=GB2312">
<title>Insert title here</title>
</head>
<body>
<%
java.sql.Connection conn;
java.lang.String strConn;
java.sql.Statement sqlStmt;
java.ResultSet sqlRst;
try
{
Class.forName
("com.microsoft.jdbc.sqlserver.SQLServerDriver").newlnstance();
String url=
"jdbc:microsoft:sqlserver://localhost:1433:DatabaseName=J2EE";
String dbUser="";
String dbPassword="";
conn=java.sql.DriverManager.getConnection(url,dbRser,dbPassword);
sqlStmt=conn.creatStatement();
String sqlStr="insert";
sqlStmt.execute(sqlStr);
String sqlStr2="select ID,Name from j2ee";
sqlRst=sqlStmt.executeQuery(sqlStr2);
}
%>
<table border="1" width="100%" bordercolorlight="#CC99FF" cellpadding="2"
bordercolordark="#FFFFFF" cellspacing="0">
<tr>
<td align="center"> ID</td>
<td align="center">Name</td>
</tr>
<%while (sqlRst.next()){//取得下一条记录 %>
<tr>
<td><%=sqlRst.getString("ID") %></td>
<td><%=new String(sqlRst.getString("Name") %></td>
</tr>
<%} %>
</table>
<%
sqlRst.close();
sqlStmt.close();
conn.close();
}
catch (java.sql.SQLException e){
}
}
%>
</body>
</html>
pageEncoding="GB2312"%>
<!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=GB2312">
<title>Insert title here</title>
</head>
<body>
<%
java.sql.Connection conn;
java.lang.String strConn;
java.sql.Statement sqlStmt;
java.ResultSet sqlRst;
try
{
Class.forName
("com.microsoft.jdbc.sqlserver.SQLServerDriver").newlnstance();
String url=
"jdbc:microsoft:sqlserver://localhost:1433:DatabaseName=J2EE";
String dbUser="";
String dbPassword="";
conn=java.sql.DriverManager.getConnection(url,dbRser,dbPassword);
sqlStmt=conn.creatStatement();
String sqlStr="insert";
sqlStmt.execute(sqlStr);
String sqlStr2="select ID,Name from j2ee";
sqlRst=sqlStmt.executeQuery(sqlStr2);
}
%>
<table border="1" width="100%" bordercolorlight="#CC99FF" cellpadding="2"
bordercolordark="#FFFFFF" cellspacing="0">
<tr>
<td align="center"> ID</td>
<td align="center">Name</td>
</tr>
<%while (sqlRst.next()){//取得下一条记录 %>
<tr>
<td><%=sqlRst.getString("ID") %></td>
<td><%=new String(sqlRst.getString("Name") %></td>
</tr>
<%} %>
</table>
<%
sqlRst.close();
sqlStmt.close();
conn.close();
}
catch (java.sql.SQLException e){
}
}
%>
</body>
</html>
