0568. [JSP] (tomcat mysql jsp) mysql tomcat 연동 jsp
mysql-connector-java-5.1.26-bin.jar 파일 다운로드
http://dev.mysql.com/downloads/connector/j/
/usr/local/java/jre/lib/ext/mysql-connector-java-5.1.26-bin.jar
/usr/local/server/tomcat/lib
lrwxrwxrwx. 1 root root 63 Nov 6 08:08 mysql-connector-java-5.1.26-bin.jar -> /usr/local/java/jre/lib/ext/mysql-connector-java-5.1.26-bin.jar
[root@linuxtest webapps]# cat mysqlconn.jsp
<%@ page language="java" import="java.util.*, java.sql.*" session="true"
contentType="text/html;charset=UTF-8" %>
<html>
<head>
<title> mysql jdbc test</title>
</head>
<body>
<table border=1 cellpadding=0 cellspacing=0>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String jdbcUrl = "jdbc:mysql://10.20.12.82:3306/";
String dbUser = "root";
String dbPass = "art";
try {
Class.forName("com.mysql.jdbc.Driver");
} catch(ClassNotFoundException e){
System.out.println("Mysql jdbc driver loading err");
out.println("Mysql jdbc driver loading err");
out.println(e.toString());
return;
}
try {
con=DriverManager.getConnection(jdbcUrl,dbUser,dbPass);
} catch(SQLException e) {
System.out.println("Mysql connection err");
out.println("Mysql connection err");
out.println(e.toString());
return;
}
try {
stmt = con.createStatement();
String query = "SHOW STATUS";
rs = stmt.executeQuery(query);
while(rs.next()) {
out.println("<tr>");
out.println("<td>"+rs.getString(1)+"</td>");
out.println("<td>"+rs.getString(2)+"</td>");
// out.println("<td>"+rs.getString(3)+"</td>");
out.println("<tr>");
}
} catch (SQLException e){
out.println(e.toString());
}
//*
try {
if(rs !=null) rs.close();
if(stmt !=null) stmt.close();
if(con !=null) con.close();
} catch (SQLException e){
out.println(e.toString());
}
// */
%>
</table>
</BODY>
</HTML>
'IT' 카테고리의 다른 글
| 0570. [LINUX] (SAMBA) <smb.conf>CentOS SAMBA smb.conf 환경설정 (0) | 2016.03.18 |
|---|---|
| 0569. [LINUX] (SAMBA) CentOS SAMBA 설치 (0) | 2016.03.18 |
| 0567. [LINUX] (setsebool) SELinux ftp_home_dir 오픈하기 (0) | 2016.03.18 |
| 0566. [LINUX] (vsftpd) vsftpd 설치 (0) | 2016.03.18 |
| 0565. [LINUX] (tomcat) tomat src 설치하기 (0) | 2016.03.17 |
