jsp jdbc mysql数据库_jsp：JDBCmysql数据库连接

com.test;importjava.io.IOException;importjava.io.PrintWriter;import java.sql.*;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;public class GetMysql extendsHttpServlet {/*** Constructor of the object.*/

publicGetMysql() {super();

}/*** Destruction of the servlet.
*/

public voiddestroy() {super.destroy(); //Just puts "destroy" string in log//Put your code here

}/*** The doGet method of the servlet.

*

* This method is called when a form has its tag value method equals to get.

*

*@paramrequest the request send by the client to the server

*@paramresponse the response send by the server to the client

*@throwsServletException if an error occurred

*@throwsIOException 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 voiddoGet(HttpServletRequest request, HttpServletResponse response)throwsServletException, 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("");

}//关闭通道

rs.close();

conn.close();

stmt.close();

}catch(Exception e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}/*** The doPost method of the servlet.

*

* This method is called when a form has its tag value method equals to post.

*

*@paramrequest the request send by the client to the server

*@paramresponse the response send by the server to the client

*@throwsServletException if an error occurred

*@throwsIOException if an error occurred*/

public voiddoPost(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException {

response.setContentType("text/html");

PrintWriter out=response.getWriter();

out.println(""-//W3C//DTD HTML 4.01 Transitional//EN\">");

out.println("");

out.println("

A Servlet");

out.println("

");

out.print(" This is ");

out.print(this.getClass());

out.println(", using the POST method");

out.println(" ");

out.println("");

out.flush();

out.close();

}/*** Initialization of the servlet.

*

*@throwsServletException if an error occurs*/

public void init() throwsServletException {//Put your code here

}

}

jsp：JDBCmysql数据库连接

标签：close   gets   cat   response   error   gen   void   gpo   write

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://www.cnblogs.com/dybe/p/8099164.html