wood burning stoves 2.0*
The moose likes JDBC and the fly likes Updating a derby database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Updating a derby database" Watch "Updating a derby database" New topic
Author

Updating a derby database

Ventris Learchus
Greenhorn

Joined: Apr 10, 2013
Posts: 6
HI guys I want to develop a form which upon clicking submit will add data to a derby database . at the moment I've researched using http://courses.coreservlets.com/Course-Materials/pdf/msajsp/10-JDBC.pdf and using their source code however I am unsure how to add the data , does anyone now how to do this ? the form will pass the data via a simple action = POST

Here is the current code for the database creation that i am using

import java.sql.; import java.util.;

import javax.servlet.http.Cookie;

/** Creates "myDatabase" DB and "Users" table.
* <p>
* From <a href="http://courses.coreservlets.com/Course-Materials/">the
* coreservlets.com tutorials on servlets, JSP, Struts, JSF, Ajax, GWT,
* Spring, Hibernate/JPA, and Java programming</a>.
*/



public class EmbeddedDbCreator {
// Driver class not needed in JDBC 4.0 (Java SE 6)
// private String driver = "org.apache.derby.jdbc.EmbeddedDriver";
private String protocol = "jdbc:derby:";
private String username = "bleh";
private String password = "tomcat";
private String dbName = "myDatabase";
private String tableName = "Users";
private Properties userInfo;

public EmbeddedDbCreator() {
userInfo = new Properties();
userInfo.put("user", username);
userInfo.put("password", password);
}

public void createDatabase() {
User[] Users = {
new User(1, "Graham",1),
new User(2, "Aaron",4),
new User(3, "Dan",2),
new User(4, "James",3),
new User(5, "David",5),
};



try {
String dbUrl = protocol + dbName + ";create=true";
Connection connection = DriverManager.getConnection(dbUrl, userInfo);
Statement statement = connection.createStatement();
String format = "VARCHAR(20)";
String tableDescription =
String.format
("CREATE TABLE %s" +
"(id INT, firstname %s , score INT)",
tableName, format, format, format);
statement.execute(tableDescription);
String template =
String.format("INSERT INTO %s VALUES(?, ?, ?, ?, ?)",
tableName);
PreparedStatement inserter =
connection.prepareStatement(template);
for(User e: Users) {
inserter.setInt(1, e.getUserID());
inserter.setString(2, e.getFirstName());
inserter.setInt(1, e.getscore());
inserter.executeUpdate();
System.out.printf("Inserted %s %s.%n",
e.getFirstName());
}
inserter.close();
connection.close();
} catch (SQLException sqle) {
// If table already exists, then skip everything else
}
}

public void showTable() {
try {
String dbUrl = protocol + dbName;
Connection connection;
connection = DriverManager.getConnection(dbUrl, userInfo);
Statement statement = connection.createStatement();
String query =
String.format("SELECT * FROM %s",tableName);
ResultSet resultSet = statement.executeQuery(query);
while(resultSet.next()) {
int id = resultSet.getInt("id");
String firstName = resultSet.getString("firstname");
System.out.printf("%s %s (%s, id=%s)",
firstName, id);
}
connection.close();
} catch (SQLException sqle) {
sqle.printStackTrace();
}
}

public static void main(String[] args) {
EmbeddedDbCreator tester = new EmbeddedDbCreator();
tester.createDatabase();
tester.showTable();
}
}
IF someone could show me what the function to add a user would look like as well as how to call this in a jsp i'd really appreciate it

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Updating a derby database
 
Similar Threads
what's wrong
how to show database table with webservice?
Problem with update and create methods in MVC
NPE
how to retrive database table data with webService?