40分求解下面的一个jsp与mysql的有关问题
日期：2014-05-18 浏览次数：20638 次
40分求解下面的一个jsp与mysql的问题
各位高手哥:
我在做一个网站的检索,请问怎么用jsp语言操作mysql中的一个表,并按指定方式生成一个临时表.使用完成之后并删除.
直接操作,我还行,可是用jsp来操作,我要哭了,高手们请指点一下吧!
------解决方案--------------------
用jdbc 调用 drop table 语句就可以了
------解决方案--------------------
<%@ page import= "java.sql.* "%>
<%@ page contentType= "text/html; charset=GB2312 " %>
<html>
<head>
<title> 使用JSP连接MySQL数据库案例测试 </title>
</head>
<body>
<%
Connection con;
Statement stmt;
ResultSet rs;
Class.forName( "com.mysql.jdbc.Driver ");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl = "jdbc:mysql://localhost:3306/mysql?user=root&password=860317&useUnicode=true&characterEncoding=gb2312 ";
con= DriverManager.getConnection(dbUrl);
//创建一个JDBC声明
stmt = con.createStatement();
rs = stmt.executeQuery( "select user from user ");
//输出查询结果
out.println( " <table border=1 width=400> ");
while (rs.next())
{
String col1 = rs.getString(1);
String col2 = rs.getString(2);
//String col3 = rs.getString(3);
//String col4 = rs.getString(4);
//打印所显示的数据
out.println( " <tr> <td> "+col1+ " </td> <td> "+col2+ " </td> ");
}
out.println( " </table> ");
//关闭数据库连接
rs.close();
stmt.close();
con.close();
%>
</body>
</html>
------解决方案--------------------
<%@ page contentType= "text/html; charset=GB2312 "%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN ">
<html>
<head>
<title> Operate Mysql </title>
<meta http-equiv= "pragma " content= "no-cache ">
<meta http-equiv= "cache-control " content= "no-cache ">
<meta http-equiv= "expires " content= "0 ">
<meta http-equiv= "keywords " content= "keyword1,keyword2,keyword3 ">
<meta http-equiv= "description " content= "This is my page ">
<!--
<link rel= "stylesheet " type= "text/css " href= "styles.css ">
-->
</head>
<body>
<%
Class.forName( "com.mysql.jdbc.Driver ");
java.sql.Connection connection=java.sql.DriverManager.getConnection( "jdbc:mysql://localhost/test?user=root ");
java.sql.Statement stmt=connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE);
stmt.execute( "create table jsp(jspName VARCHAR(10)) ");
stmt.execute( "insert into jsp values( 'abc ') ");
stmt.execute( "insert into jsp values( 'def ') ");
java.sql.ResultSet rs=stmt.executeQuery( "select jspName from jsp ");
while(rs.next())
{
%>
<%=rs.getString(1) %> <br>
<%
}
rs.close();
stmt.execute( "drop table jsp ");
stmt.close();
connection.close();
%>
</body>
</html>
------解决方案--------------------
各位高手哥:
我在做一个网站的检索,请问怎么用jsp语言操作mysql中的一个表,并按指定方式生成一个临时表.使用完成之后并删除.
直接操作,我还行,可是用jsp来操作,我要哭了,高手们请指点一下吧!
------解决方案--------------------
用jdbc 调用 drop table 语句就可以了
------解决方案--------------------
<%@ page import= "java.sql.* "%>
<%@ page contentType= "text/html; charset=GB2312 " %>
<html>
<head>
<title> 使用JSP连接MySQL数据库案例测试 </title>
</head>
<body>
<%
Connection con;
Statement stmt;
ResultSet rs;
Class.forName( "com.mysql.jdbc.Driver ");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl = "jdbc:mysql://localhost:3306/mysql?user=root&password=860317&useUnicode=true&characterEncoding=gb2312 ";
con= DriverManager.getConnection(dbUrl);
//创建一个JDBC声明
stmt = con.createStatement();
rs = stmt.executeQuery( "select user from user ");
//输出查询结果
out.println( " <table border=1 width=400> ");
while (rs.next())
{
String col1 = rs.getString(1);
String col2 = rs.getString(2);
//String col3 = rs.getString(3);
//String col4 = rs.getString(4);
//打印所显示的数据
out.println( " <tr> <td> "+col1+ " </td> <td> "+col2+ " </td> ");
}
out.println( " </table> ");
//关闭数据库连接
rs.close();
stmt.close();
con.close();
%>
</body>
</html>
------解决方案--------------------
<%@ page contentType= "text/html; charset=GB2312 "%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN ">
<html>
<head>
<title> Operate Mysql </title>
<meta http-equiv= "pragma " content= "no-cache ">
<meta http-equiv= "cache-control " content= "no-cache ">
<meta http-equiv= "expires " content= "0 ">
<meta http-equiv= "keywords " content= "keyword1,keyword2,keyword3 ">
<meta http-equiv= "description " content= "This is my page ">
<!--
<link rel= "stylesheet " type= "text/css " href= "styles.css ">
-->
</head>
<body>
<%
Class.forName( "com.mysql.jdbc.Driver ");
java.sql.Connection connection=java.sql.DriverManager.getConnection( "jdbc:mysql://localhost/test?user=root ");
java.sql.Statement stmt=connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE);
stmt.execute( "create table jsp(jspName VARCHAR(10)) ");
stmt.execute( "insert into jsp values( 'abc ') ");
stmt.execute( "insert into jsp values( 'def ') ");
java.sql.ResultSet rs=stmt.executeQuery( "select jspName from jsp ");
while(rs.next())
{
%>
<%=rs.getString(1) %> <br>
<%
}
rs.close();
stmt.execute( "drop table jsp ");
stmt.close();
connection.close();
%>
</body>
</html>
------解决方案--------------------
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
