ورود

View Full Version : مشکل در value کلاس insert کردن



yegane8
شنبه 13 خرداد 1391, 23:24 عصر
سلام

من باید چه تغییری در کد زیر انجام بدم تا کاربر value‌ها را وارد کند
import java.sql.*;
public class Insert
{
private static Connection link;
private static Statement statement;


public static void main(String[] args) throws ClassNotFoundException, SQLException
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
link = DriverManager.getConnection("jdbc:odbc:Students","","");
statement = link.createStatement();
statement.executeUpdate("INSERT INTO Identify"+ " VALUES (878777,'ahmad','ahmadi',0)");
link.close();
System.out.println("Your record insert successfully");

}
}

mortezaadi
دوشنبه 15 خرداد 1391, 00:27 صبح
public static void main(String[] args) throws ClassNotFoundException, SQLException
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
link = DriverManager.getConnection("jdbc:odbc:Students"," ","");
String sql = "INSERT INTO Identify VALUES (?,?,?,?)";
PreparedStatement prest = link.prepareStatement(sql);
BufferedReader bf = new BufferedReader(new InputStreamReader(System.in));
System.out.println("Enter Student no:"); // or whatever the first item is
int stNo = Integer.parseInt(bf.readLine());
prest.setInt(1, stNo);
System.out.println("Enter Student Name:");
String name = bf.readLine();
prest.setString(2, name);
System.out.println("Enter Student LastName:");
String lname = bf.readLine();
prest.setString(3, lname);
System.out.println("Enter a number:");
int n = Integer.parseInt(bf.readLine());
prest.setInt(4, n);
int count = prest.executeUpdate();

link.close();
System.out.println("Your record insert successfully");
System.out.println(count + "row(s) affected");

}