Changeset 10294
- Timestamp:
- 2005-07-25T16:17:22+12:00 (19 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/database/GS3SQLConnectionFactory.java
r9874 r10294 4 4 import java.sql.DriverManager; 5 5 import java.sql.SQLException; 6 6 import java.io.InputStream; 7 import java.util.Properties; 8 import org.greenstone.gsdl3.util.GlobalProperties; 7 9 8 10 public class GS3SQLConnectionFactory 9 11 { 12 10 13 public static Connection getConnection(String database) 11 14 { 12 try { 15 try { 16 String server = GlobalProperties.getProperty("mysql.server", "localhost"); 17 String port = GlobalProperties.getProperty("mysql.tcp.port", "3306"); 18 String password = GlobalProperties.getProperty("mysql.gsdl3admin.password"); 19 13 20 Class.forName("com.mysql.jdbc.Driver").newInstance(); 14 15 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/"+database+"?user=gsdl3admin"/*&password=greenstone"*/); 21 String connection_address = "jdbc:mysql://"+server+":"+port+"/"+database+"?user=gsdl3admin"; 22 if (password != null) { 23 connection_address += "&password="+password; 24 } 25 Connection connection = DriverManager.getConnection(connection_address); 16 26 return connection; 17 27 } 18 catch (SQLException sqlEx) 19 { System.out.println(sqlEx.toString()); 20 } 21 catch (Exception ex) 22 { System.out.println(ex.toString()); 23 return null; 24 } 28 catch (SQLException sqlEx) { 29 System.out.println(sqlEx.toString()); 30 } 31 catch (Exception ex) { 32 System.out.println(ex.toString()); 33 } 25 34 return null; 26 35 }
Note:
See TracChangeset
for help on using the changeset viewer.