🚀 go-pugleaf

(Pino) wrote:
>>Gaizka wrote 
>> Welke DB dacht je te gebruiken ?
>> 
>MsAcces, ik weet dat het niet goed is om veel gebruikers toe te laten, maar 
>ik kan er al wat mee werken.

Stap1

Set up a DSN for your Access database.

�  Open the Windows ODBC Data Source Administrator as follows:

�  In Windows 95, 98, or NT, choose Start > Settings > Control Panel,
then double click on the ODBC Data Sources icon 
�  In Windows 2000, choose Start > Settings > Control Panel >
Administrative Tools > Data Sources 
 
�  In the ODBC Data Source Administrator dialog box, click the System
DSN tab, then click Add to add a new DSN to the list. 
�  Select "Microsoft Access Driver (*.mdb) from the list, then click
Finish 
�  Specify a name for the DSN, like myAccessDatabase 
�  Click Select to locate your Access database file on your hard drive
�  Click OK to close the dialog box 

Stap 2

test.html

<html>
<head>
</head>
<body>
<form action="insert.jsp">
Field1:
<input type="text" name="fieldname1" size="20">
<br>
Field2:
<input type="text" name="fieldname2" size="20">
<input type="submit" value="ok">
</form>
</body>
</html>

insert.jsp

//verwerk dbname door de naam van jouw DB

<%@ page import="java.sql.*" %>
<%  
	Connection connection;
	try
	{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	connection =DriverManager.getConnection("jdbc:odbc:dbname");
	Statement statement=connection.createStatement();
	String  var1= request.getParameter("fieldname1");
	String  var1= request.getParameter("fieldname2");
	String sql = "insert into dbname values ('"+fieldname1+"',
'"+fieldname2+"')";
	statement.executeUpdate(sql); 	
	statement.close();
	connection.close();
	 }
	catch(ClassNotFoundException cnfex)
	{
		 out.println("jdbc odbc driver not found");
	}
	catch(SQLException sqlex)	
	{
		 out.println(sqlex);
	}
%>
Operation successfull

Misschien 
http://www.devshed.com/Server_Side/Java/JSP/JSP5/page1.html
ook is bekijken