JSP(제이에스피) DB(디비) Connect(접속)

11년 8월 기준.

 

package talktab.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class dbtest {

public static boolean dbtest(){

Connection conn;

Statement stmt;

 

try{

Class.forName("com.mysql.jdbc.Driver");

 

}catch(ClassNotFoundException e){

System.err.print("ClassNotFoundException: ");

return false;

}

 

try{

String url="jdbc:mysql://192.168.0.100:3306/talktab";

String id="mysql";

String pass="mysql";

conn = DriverManager.getConnection(url,id,pass);

stmt=conn.createStatement();

 

stmt.close();

conn.close();

 

System.out.println("connect");

 

}catch(SQLException e){

System.out.println("SQLException: "+e.getMessage());

return false;

}

return true;

}

 

}