SampleInsert.jsp
Dosyayı İndir
<%@page import="java.sql.*"%>
<%
String message = "L�tfen bilgileri giriniz.";
String insert = request.getParameter("insert");
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>Varl�k-��letmeci</title>
</head>
<body>
<h1>�rnek Ekleme</h1>
<i><%=message%></i><br/><br/>
<form>
�rnek Ad� : <input type="text" name="sampleName"/><br/><br/>
�rnek De�er : <input type="text" name="sampleValue"/><br/><br/>
<input type="submit" value="Ekle" name="insert"/>
</form>
</body>
</html>
Dosyayı İndir 