Wednesday, June 30, 2010

Connect to Mysql database in JSP

Statement stmnt = null; // statement for category
Statement stmnt2 = null; // statement for book
Statement stmnt3 = null; // statement for thumbnail
ResultSet query = null;
Connection conn = null;
ResultSet getBooks = null;
ResultSet getThumbnail = null;
//InputStream thumbnail = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
}catch (ClassNotFoundException cnf){
System.out.print("Error");
}

try{
conn = DriverManager.getConnection("jdbc:mysql://localhost/ebooks", "root", "thuyhien");
stmnt = (Statement) conn.createStatement();
stmnt2 = (Statement) conn.createStatement();
query = stmnt.executeQuery("Select * from Category");
getBooks = stmnt2.executeQuery("select * from Books");
}catch (SQLException sex){
System.out.println("Unable to connect to database");
}

No comments:

Post a Comment