iframe-proxy | Sunbelt Computer Software

41 lines (34 loc) · 1020 Bytes

package com.pak;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class prepared {
	public static Connection getconnection(){
		Class.forName("com.mysql.jdbc.Driver");
			Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
			return conn;
		catch (ClassNotFoundException | SQLException e) {
		e.printStackTrace();
	return null;
	public static void main(String[] args) {
		Connection conn = prepared.getconnection();
		PreparedStatement sql =conn.prepareStatement("insert into student values(?,?,?)");
		PreparedStatement sql1=conn.prepareStatement("delete from student where values(?,?)");
		sql.setInt(1,1);
		sql.setString(2,"Anuj");
		sql.setString(3,"Raval");
		int i=sql.executeUpdate();
		System.out.println(i+"Records inserted");
		conn.close();
		catch (SQLException e){
			e.printStackTrace();

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

prepared.java

Latest commit

History

prepared.java

File metadata and controls