|
1 package forum;
2
3 import javax.servlet.*;
4 import javax.servlet.http.*;
5 import java.sql.*;
6 import java.sql.Connection  ;
7 import java.sql.Statement ;
8 import java.sql.ResultSet ;
9 import org.gjt.mm.mysql.*;
10
11 public class DBConnectie{
12
13 String DBName, DBUser, DBPass, SQLQuery;
14 Connection conn;
15 Statement stmt;
16 ResultSet result;
17
18 public DBConnectie(String DBName, String DBUser, String DBPass){
19 this.DBName = DBName;
20 this.DBUser = DBUser;
21 this.DBPass = DBPass;
22 try {
23 Class.forName("org.gjt.mm.mysql.Driver");
24 }catch(Exception e){}
25 }
26
27 public void connect() {
28 try {
29 conn = DriverManager.getConnection("jdbc:mysql://localhost/" + DBName + "?user=" + DBUser + "&password=" + DBPass);
30 }catch(Exception e){}
31 }
32
33 public ResultSet selectQuery(String SQLQuery){
34 this.SQLQuery = SQLQuery;
35
36 try {
37 stmt = conn.createStatement();
38 result = stmt.executeQuery( SQLQuery );
39 }
40 catch( Exception e ){}
41 return result;
42 }
43
44 public void query(String SQLQuery){
45 this.SQLQuery = SQLQuery;
46 try {
47 stmt = conn.createStatement();
48 stmt.executeQuery( SQLQuery );
49 }
50 catch( Exception e ){}
51 }
52
53 public void close(){
54 try {
55 stmt.close();
56 conn.close();
57 }
58 catch(Exception e){}
59 }
60 }
61
62 |
Popular Tags |
Java API By Example, From Geeks To Geeks.