SampleInsert.jsp
Dosyayı İndir
<%--
Document : SampleInsert
Created on : May 21, 2013, 7:05:57 PM
Author : onder
--%>
<%@page import="java.sql.*"%>
<%
String insert = request.getParameter("insert");
String message = "L�tfen bilgileri giriniz.";
if (insert != null) {
String sampleName = request.getParameter("sampleName");
double sampleValue = Double.parseDouble(request.getParameter("sampleValue"));
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/webdb";
String user = "root";
String password = "godoro";
Connection connection = DriverManager.getConnection(url, user, password);
String sql = "insert into Sample(sampleName,sampleValue) values(?,?)";
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, sampleName);
statement.setDouble(2, sampleValue);
int affected = statement.executeUpdate();
message = affected+" kay�t eklendi " + sampleName + " " + sampleValue;
connection.close();
}
%>
<%@page contentType="text/html" pageEncoding="iso-8859-9"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<title>JSP Page</title>
</head>
<body>
<h1>�rnek Ekleme</h1>
<i><%=message%></i>
<form>
�rnek Ad� : <input type="text" name="sampleName"/><br/>
�rnek De�er : <input type="text" name="sampleValue"/><br/>
<input type="submit" value="Ekle" name="insert"/>
</form>
</body>
</html>
Dosyayı İndir 