jsp：JDBCmysql数据库连接
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了jsp：JDBCmysql数据库连接，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3478字，纯文字阅读大概需要5分钟。
内容图文
com.test;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class GetMysql extends HttpServlet {
/**
* Constructor of the object.
*/
public GetMysql() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
private static final long serUid=1L;
//加载驱动
static final String jdbc="com.mysql.jdbc.Driver";
//要连接的数据库url
static final String db_url="jdbc:mysql://localhost:3306/test";
//数据库用户名
static final String user="dyb";
//数据库密码
static final String pass="174372150";
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn=null;
Statement stmt=null;
//显示的数据的格式
response.setContentType("text/html;charset=UTF-8");
PrintWriter out =response.getWriter();
try {
Class.forName("com.mysql.jdbc.Driver");
//输入用户名密码和连接。
conn=DriverManager.getConnection(db_url,user,pass);
//用于向数据库发送sql语句
stmt=conn.createStatement();
String sql=null;
//输入sql语句获取想要的数据
sql="SELECT t.title,t.new_id," +
"t.news_type_id,t.new_date," +
"d.name FROM t_news t " +
"JOIN t_type_id d on t.news_type_id=d.t_type_id";
//发送sql语句并返回结果
ResultSet rs=stmt.executeQuery(sql);
//循环遍历打印结果
while (rs.next()) {
int id=rs.getInt("t.news_type_id");
String lr=rs.getString("t.title");
String dd=rs.getString("t.new_date");
String name=rs.getString("d.name");
out.print("ID:"+id);
out.print("内容："+lr);
out.print("日期："+dd);
out.print("名称："+name);
out.println("</BR>");
}
//关闭通道
rs.close();
conn.close();
stmt.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the POST method");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
jsp：JDBCmysql数据库连接
标签：close gets cat response error gen void gpo write
本文系统来源：http://www.cnblogs.com/dybe/p/8099164.html
内容总结
以上是互联网集市为您收集整理的jsp：JDBCmysql数据库连接全部内容，希望文章能够帮你解决jsp：JDBCmysql数据库连接所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】