1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<%@page import = "java.sql.*"%>
<%
try{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//Connection connection=DriverManager.getConnection("jdbc:odbc:db1","","");
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:8080/test","root", "root");
Statement statement=connection.createStatement();
String query;
query="create table if not exists Contacts (ContactID INT AUTO_INCREMENT NOT NULL,"+"FirstName VARCHAR(30) NOT NULL,"+"LastName VARCHAR(30) NOT NULL,"+"Address VARCHAR(50) NOT NULL,"+"PRIMARY KEY (ContactID))";
statement.executeUpdate(query);
query="INSERT INTO Contacts(FirstName, LastName, Address) VALUES ('Alan','Smith','3 Berry Street')";
statement.executeQuery(query);
out.println("Successful!");
} catch (Exception e) {
//e.printStackTrace();
out.println(e.toString());
}
%> |
