简单问题,怎样用jsp连 mysql数据库? http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=46262http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=15371 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 下载个mysql的jdbc驱动程序 然后加载到classpath中, 连接数据库的代码如下: <% Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","",""); Statement stmt=conn.createStatement(); String sql="select * from dbname"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) { } %> 下载:http://expert.csdn.net/Expert/topic/1438/1438720.xml?temp=.2002832 你有mysql的jdbc驱动吗?如果有,其帮助中讲得很清楚。又或者你有mysql的使用帮助,也可以找到相关内容,也可以去www.google.com里搜索"jdbc mysql 连接 数据库" 一、下载JDBC驱动程序二、安装JDBC驱动程序三、测试程序test.jsp<%@ page language="java" import="java.io.*,java.sql.*,javax.sql.* ,javax.naming.*"%><%@ page contentType="text/html;charset=gb2312" %> <% String sDBDriver = "org.gjt.mm.mysql.Driver"; String sConnStr = "jdbc:mysql://localhost:3306/test"; Connection conn = null; ResultSet rs = null; Statement stmt = null; try { Class.forName(sDBDriver); conn = DriverManager.getConnection(sConnStr,"jincheng","781126"); stmt = conn.createStatement(); //stmt.executeQuery("create table aaa(aaa int)");//stmt.executeUpdate("insert into bbb values(456)"); rs = stmt.executeQuery("select aaa from bbb"); while (rs.next()){ out.println("" + rs.getInt(1) + ""); out.println(":"+"<br>"); //out.println(" + rs.getString('answers') + "); } rs.close(); } catch(Exception e) { out.println(e); } %> 帮我解决个小问题啊 简单的SERVLET处理登入有问题 帮帮忙了 谢谢 感谢csdn一年的帮助!顺便ask~ jsp 问题 structs jsp与formbean的传值问题 Click(这里我使用了Active Control)一个按钮时老蹦出来一句话,用程序怎么屏蔽掉它? 关于如何使用wincvs进行异地开发 jsp http 404 错误,尝试了N中方法 求教在如何服务器端建立文件夹?救命啊! 一点小问题,请教大家! 请问怎样安装与配置apache和tomcat 如何获得Option元素当前所显示的值????
然后加载到classpath中,
连接数据库的代码如下:
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","","");
Statement stmt=conn.createStatement();
String sql="select * from dbname";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
}
%>
http://expert.csdn.net/Expert/topic/1438/1438720.xml?temp=.2002832
二、安装JDBC驱动程序
三、测试程序test.jsp<%@ page language="java" import="java.io.*,java.sql.*,javax.sql.* ,javax.naming.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%
String sDBDriver = "org.gjt.mm.mysql.Driver";
String sConnStr = "jdbc:mysql://localhost:3306/test"; Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr,"jincheng","781126");
stmt = conn.createStatement();
//stmt.executeQuery("create table aaa(aaa int)");
//stmt.executeUpdate("insert into bbb values(456)"); rs = stmt.executeQuery("select aaa from bbb");
while (rs.next()){
out.println("" + rs.getInt(1) + "");
out.println(":"+"<br>");
//out.println(" + rs.getString('answers') + ");
}
rs.close(); }
catch(Exception e)
{
out.println(e);
}
%>