jsp：JDBCmysql数据库连接
时间：2021-07-01 10:21:17
帮助过：20人阅读
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
