JSP连MySQL
来源:互联网 发布:佳仁按摩椅怎么样知乎 编辑:程序博客网 时间:2024/05/20 07:53
<%
String sql = "";
String url = "";
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
url = "jdbc:mysql://localhost/myDB?user=root&password=123456&useUnicode=true&characterEncoding=gb2312";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
sql = "select Id, Name, Address from myTable";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()){
out.println("<information id=/"" + rs.getString(1) + "/">");
out.println("<id>" + rs.getInt(1) + "</id>");
out.println("<name>" + rs.getString(2) + "</name>");
out.println("<address>" + rs.getString(3) + "</address>");
out.println("</information>");
}
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
out.println(e);
}
%>
- jsp连mysql
- JSP连MySQL
- JSP连mysql数据库
- jsp连Mysql+Oracle数据库
- JSP直连MYSQL代码示例
- jsp连sql数据库
- jsp连数据库大全
- jsp连动菜单
- jsp直连 db2代码
- jsp直连sqlserver代码
- Java连数据库JSP例子
- jsp连sql server2000 (经验)
- jsp连sql server2000数据库
- jsp连数据库入门测试
- JAVA 连MYSQL
- VC++连MySQL
- C语言连MySQL
- ASP连MYSQL
- JavaScript 技巧与高级特性
- FI--SAP财务成本知识库
- JavaFX尝鲜
- QQ协议网络协议:请求部份
- 基于HTTP的QQ协议V1.1的不完整成果,拿出来与大家分享一下
- JSP连MySQL
- 写了个小型聊天程序
- 第一章 初识C#
- PDA?掌上电脑?智能手机?-PDA入门必读
- 寻书: Handbook of Stochastic Methods: For Physics, Chemistry and the Natural Sciences
- linux下安装mysql
- 在Ruby中进行网络协议开发初探
- VC6.0附带小工具软件一览
- 谋划(26)