Package com.mysql.jdbc.jdbc2.optional

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
      return l_artifact_ids;
  }
 
  public static LinkedList<Long> getArtifacts(long group_artifact_id)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<Long> l_artifact_ids = new LinkedList<Long>();
     
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement(); 

       
      ResultSet s = l_stat.executeQuery("select artifact_id from artifact where group_artifact_id = " + group_artifact_id);
     
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
      return l_artifact_ids;
  }
 
  public static Artifact getArtifact(long artifact_id)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      Artifact l_artifact = null;
     
     
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement(); 

       
      ResultSet s = l_stat.executeQuery("select artifact_id, group_artifact_id, status_id, category_id, artifact_group_id," +
          " resolution_id, priority, submitted_by, assigned_to, from_unixtime(open_date) as open_date, from_unixtime(close_date) as close_date, " +
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
    m_revision_user_id = mRevisionUserId;
  }
 
  public static LinkedList<CVS_revision> getRevisions(long modul_id, Date begin, Date end)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<CVS_revision> l_revisions = new LinkedList<CVS_revision>();
     
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement(); 

        String str ="select revision_id, revision_modul_id, from_unixtime(revision_date) revision_date, revision_author_name, revision_user_id "+
        " from cvs_revision where revision_modul_id = " + modul_id + " and from_unixtime(revision_date) > '" +df.format(begin)
        + "' and from_unixtime(revision_date) < '"+ df.format(end) +"' and revision_user_id <> 0";
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
    m_name=name;
  }
 
  public static LinkedList<Long> getGroupArtifactIDsByGroupID(long group_id)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<Long> l_group_artifact_ids = new LinkedList<Long>();
     
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement(); 

       
      ResultSet s = l_stat.executeQuery("select group_artifact_id from artifact_group_list where group_id = " + group_id);
     
View Full Code Here
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  private long group_id = 0;
  private String group_name = null;
 
  public static Hashtable <Long, String> getall_by_id_name()
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      Hashtable <Long, String> l_id_names = new Hashtable<Long, String>();
     
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement(); 

       
      ResultSet s = l_stat.executeQuery("select group_id, group_name from groups");
     
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
  private final static DateFormat df = new SimpleDateFormat("yyyy-MM-dd");

   
    public static LinkedList<Long> getModules (Date i_von, Date i_bis, long i_modul_group_id)
    {
      MysqlDataSource l_ds = DBAccess.ReturnDataSource();
        Connection l_con = null;
        Statement l_stat = null;
       
      LinkedList<Long> modul_ids = new LinkedList<Long>();
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement(); 
 
       
      ResultSet s = l_stat.executeQuery("select modul_id from cvs_modul where modul_id in (select distinct(revision_modul_id)  from cvs_revision where from_unixtime(revision_date) > '" +
          df.format(i_von) + "' and from_unixtime(revision_date) < '" + df.format(i_bis) + "') and modul_group_id = " + i_modul_group_id);
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
    m_body = body;
  }
 
  public static LinkedList<ArtifactMessage> getArtifactMessages(long artifact_id, Date begin, Date end)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<ArtifactMessage> l_artifacts = new LinkedList<ArtifactMessage>();
     
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement(); 

       
      ResultSet s = l_stat.executeQuery("select id, artifact_id, submitted_by, from_unixtime(adddate) as adddate, body from artifact_message where artifact_id = " + artifact_id
          + " and from_unixtime(adddate) > '"+ df.format(begin) + "' and from_unixtime(adddate) < '" + df.format(end) + "'");
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
    m_submitted_by = submitted_by;
    m_adddate = adddate;
  }
  public static LinkedList<ArtifactMessage> getArtifactMessages(long artifact_id)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<ArtifactMessage> l_artifact_ids = new LinkedList<ArtifactMessage>();
     
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement(); 

       
      ResultSet s = l_stat.executeQuery("select id, artifact_id, submitted_by, from_unixtime(adddate) as adddate, body from artifact_message where artifact_id = " + artifact_id);
     
View Full Code Here
444
445
446
447
448
449
450
451
452
453
454
455
456
   * due to Reference containing RefAddrs with null content.
   *
   * @throws Exception if the test fails
   */
  public void testBug16791() throws Exception {
    MysqlDataSource myDs = new MysqlDataSource();
    myDs.setUrl(dbUrl);
    Reference asRef = myDs.getReference();
    System.out.println(asRef);
   
    removeFromRef(asRef, "port");
    removeFromRef(asRef, NonRegisteringDriver.USER_PROPERTY_KEY);
    removeFromRef(asRef, NonRegisteringDriver.PASSWORD_PROPERTY_KEY);
View Full Code Here
512
513
514
515
516
517
518
519
520
521
522
523
524
    assertEquals("Connect timeout spec'd by URL didn't take", nonDefaultConnectTimeout, configuredConnectTimeout);
    assertFalse("Connect timeout spec'd by URL didn't take", defaultConnectTimeout == configuredConnectTimeout);
  }

  public void testBug42267() throws Exception {
    MysqlDataSource ds = new MysqlDataSource();
    ds.setUrl(dbUrl);
    Connection conn = ds.getConnection();
    String query = "select 1,2,345";
    PreparedStatement ps = conn.prepareStatement(query);
    String psString = ps.toString();
    assertTrue("String representation of wrapped ps should contain query string", psString.endsWith(": " + query));
    ps.close();
View Full Code Here
TOP

Related Classes of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

  • bean.DbUtility
  • bean.DbUtilitySMS
  • cn.iver.common.Config
  • com.alibaba.druid.util.MySqlUtils
  • com.carrotsearch.junitbenchmarks.mysql.MySQLConsumer
  • com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper
  • com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection
  • com.nurkiewicz.jdbcrepository.mysql.JdbcRepositoryTestMysqlConfig
  • com.proofpoint.dbpool.MySqlDataSource
  • com.taobao.metamorphosis.example.XATransactionProducer
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.