Databases
StackOverflow2013
Postsdbo
POSPRING 3 MVC - MySQL JDBC DataBase Connection Configuration
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSPRING 3 MVC - MySQL JDBC DataBase Connection Configuration
    primarykey
    data
    text
    <p>Lost in the multitude of Java API's and XML configuration.</p> <p>I am trying to create an app with the Spring MVC but struggling with the XML configuration.</p> <p>I want to be able to connect to a mysql database... but I am struggling to find any concise way of how to do it. I do not want to use Hibernate or any additional frameworks, the JDBC will be adequate on it's own.</p> <p>I would just like to be able to create a database connection and access to a String variable that can change the query as necessary. I think the problem lies within the xml configuration, but I may be wrong.</p> <p>I have pasted the details shown below in the application-context.xml file, but the server cannot be built unless I remove them. I am not sure if I am missing something simple! </p> <pre><code>&lt;bean id="JdbcDao" class="com.bcash.DbAccess.JdbcDao"&gt; &lt;property name="dataSource" ref="dataSource"/&gt; &lt;/bean&gt; &lt;bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" p:driverClassName="com.mysql.jdbc.Driver" p:url="jdbc:mysql://localhost:3306/db_name" p:username="root" p:password="" destroy-method="close" /&gt; </code></pre> <p>This is the associated class that I wrote for the xml declaration</p> <pre><code>package com.bcash.DbAccess; import javax.sql.DataSource; import org.springframework.dao.DataAccessException; import org.springframework.jdbc.core.JdbcTemplate; public class JdbcDao { private JdbcTemplate jdbcTemplate; protected String query = "INSERT INTO user('username','email','password','access_level') VALUES ('admin','test@test.com','testPassWord','admin')"; public void insertUser(){ try{ jdbcTemplate.update(query); } catch(DataAccessException e){ String error = e.getMessage(); System.out.println(error); } } } </code></pre> <p>The only error that I get is that the server could not be deployed on line 726 of the ant build script</p> <pre><code>&lt;target if="netbeans.home" name="-run-deploy-nb"&gt; &lt;nbdeploy clientUrlPart="${client.urlPart}" debugmode="false" forceRedeploy="${forceRedeploy}"/&gt; &lt;/target&gt; </code></pre> <p>Although, I am okay with PHP, I am a little confused as I am fairly new to Java. </p> <p>Thanks in advance </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser866190
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSPRING 3 MVC - MySQL JDBC DataBase Connection Configuration
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSPRING 3 MVC - MySQL JDBC DataBase Connection Configuration
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSPRING 3 MVC - MySQL JDBC DataBase Connection Configuration
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONot clear what the problem is--you're saying you can't build the project unless you remove the datasource XML config, but you get no message regarding it?
      singulars
      1. POSPRING 3 MVC - MySQL JDBC DataBase Connection Configuration
      1. USDave Newton
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload