JDBC-NET纯JAVA ????如何在web上用applet动态实现饼状图,柱状图(与数据库连接)???? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ???? JSP能不能在Lotus Notes上运行???????? 我用的是mysql,驱动包从mysql站点下载,具体例程如下:,示例如下:set CLASSPATH=e:\jdk\lib\Tools.jar;e:\jdk\lib\dt.jar;.;e:\myjsp\server;e:\jakarta-tomcat\lib\servlet.jar;e:\jdk\driver\mysql.jar;数据库连接bean:package mydb;import java.sql.*;public class conn{ String DBDriver = "org.gjt.mm.mysql.Driver";//数据库驱动 String ConnStr = "jdbc:mysql://localhost:3306/net";//net为数据库名 Connection conn = null; public conn() { try { Class.forName(DBDriver); } catch (java.lang.ClassNotFoundException error) { System.err.println(error.getMessage()); } } public Connection getconn() { try { conn = DriverManager.getConnection(ConnStr,"","");//用户和口令为空 return conn; } catch (SQLException errorc) { System.err.println(errorc.getMessage()); return null; } } public void close() { try { conn.close(); } catch (SQLException ex) { System.err.println(ex.getMessage()); } }}返回记录集beanpackage mydb;import java.sql.*;public class result{ Connection m_conn = null; Statement m_stmt = null; ResultSet m_rs = null; public result() { } public void setconn(Connection conn) { m_conn=conn; try { m_stmt = m_conn.createStatement(); } catch (SQLException ex) { System.err.println("ExecuteQuery: " + ex.getMessage()); } } public ResultSet executeQuery(String sql) { try { m_rs = m_stmt.executeQuery(sql); } catch (SQLException ex) { System.err.println("ExecuteQuery: " + ex.getMessage()); } return m_rs; } public void executeUpdate(String sql) { try { m_stmt.executeUpdate(sql); } catch (SQLException ex) { System.err.println("ExecuteQuery: " + ex.getMessage()); } } public void close() { try { m_rs.close(); m_stmt.close(); m_conn.close(); } catch (SQLException ex) { System.err.println(ex.getMessage()); } }}调用示例:<%@ page language="java" import="java.sql.*" %><jsp:useBean id="conn" class="mydb.conn" scope="page"/><jsp:useBean id="result" class="mydb.result" scope="page"/><html><head><title>Common Database Bean Test</title></head><body><%Connection myconn=conn.getconn();result.setconn(myconn);ResultSet rs=result.executeQuery("select * from bbs");while (rs.next()){ out.println("<tr>"); for(int j=1; j<=rs.getMetaData().getColumnCount(); j++){ out.println("<td>"+rs.getObject(j)+"</td>"); } out.println("</tr>"); }rs.close();result.close();myconn.close();conn.close();%></body></html> 求大虾指教~ 求大侠推荐web小项目来做 求一个jsp9大内置对象的详解或视频地址 一对多关系的数据,比如订单和订单商品,要一起显示订单和其商品信息,怎么样查询最优 登录超时,页面跳转问题 oracle 10g xe 启动不了 求JSP+ACCESS购物车程序源码 有谁做过在java中调用Project的功能生成甘特图吗 谁有把一个字串或者文件输出到一个物理路径的文件上的java代码、或者帮助。急!! 关于LIST分页的实现 请问怎样配置tomcat 在VJ++中怎样有import java.rmi 和 import javax.servlet?
?
?
? JSP能不能在Lotus Notes上运行?????
?
?
?
set CLASSPATH=e:\jdk\lib\Tools.jar;e:\jdk\lib\dt.jar;.;e:\myjsp\server;e:\jakarta-tomcat\lib\servlet.jar;e:\jdk\driver\mysql.jar;数据库连接bean:
package mydb;
import java.sql.*;
public class conn
{
String DBDriver = "org.gjt.mm.mysql.Driver";//数据库驱动
String ConnStr = "jdbc:mysql://localhost:3306/net";//net为数据库名
Connection conn = null;
public conn() {
try
{
Class.forName(DBDriver);
}
catch (java.lang.ClassNotFoundException error)
{
System.err.println(error.getMessage());
}
} public Connection getconn() {
try
{
conn = DriverManager.getConnection(ConnStr,"","");
//用户和口令为空
return conn;
}
catch (SQLException errorc)
{
System.err.println(errorc.getMessage());
return null;
}
} public void close() {
try {
conn.close();
}
catch (SQLException ex) {
System.err.println(ex.getMessage());
}
}
}返回记录集bean
package mydb;
import java.sql.*;
public class result
{
Connection m_conn = null;
Statement m_stmt = null;
ResultSet m_rs = null;
public result() {
} public void setconn(Connection conn) {
m_conn=conn;
try {
m_stmt = m_conn.createStatement();
}
catch (SQLException ex) {
System.err.println("ExecuteQuery: " + ex.getMessage());
}
} public ResultSet executeQuery(String sql) {
try {
m_rs = m_stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println("ExecuteQuery: " + ex.getMessage());
}
return m_rs;
} public void executeUpdate(String sql) {
try {
m_stmt.executeUpdate(sql);
}
catch (SQLException ex) {
System.err.println("ExecuteQuery: " + ex.getMessage());
}
} public void close() {
try {
m_rs.close();
m_stmt.close();
m_conn.close();
}
catch (SQLException ex) {
System.err.println(ex.getMessage());
}
}
}调用示例:
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="conn" class="mydb.conn" scope="page"/>
<jsp:useBean id="result" class="mydb.result" scope="page"/>
<html>
<head><title>Common Database Bean Test</title></head>
<body>
<%
Connection myconn=conn.getconn();
result.setconn(myconn);
ResultSet rs=result.executeQuery("select * from bbs");
while (rs.next()){
out.println("<tr>");
for(int j=1; j<=rs.getMetaData().getColumnCount(); j++){
out.println("<td>"+rs.getObject(j)+"</td>");
}
out.println("</tr>");
}
rs.close();
result.close();
myconn.close();
conn.close();
%>
</body>
</html>