Program For Connecting java JDBC to MySQL data base to store data in database
Posted in java programs
, learn new
No comments:
Wednesday, October 16, 2013
package jdbctest;
import java.io.Closeable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class FirstProgram {
public static void main(String[] args) {
try{
import java.io.Closeable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class FirstProgram {
public static void main(String[] args) {
try{
//load the drivers
Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver");
//connecting to the mysql data base
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/harish","root","innominds");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/harish","root","innominds");
//creating statement
Statement smt = conn.createStatement();
//smt.executeUpdate("alter table students drop last ");
//smt.executeUpdate("alter table students add column last varchar(15)");
//smt.executeUpdate("delete from students where id = 8");
//smt.executeUpdate("insert into students values(9,'pradeep','kumar','inter','mpc',54636,85,'pass','A')");
System.out.println("data is inserting to the databade......");
ResultSet rs= smt.executeQuery("select * from students");
while(rs.next())
{
System.out.println("id - "+rs.getInt(1)+" "+"fname - "+rs.getString(2)+" "+"lname - "+rs.getString(3)+" "+"class - "+rs.getString(4)+" "+"subject - "+rs.getString(5)+" "+"mobileno - "+rs.getInt(6)+" "+"marks - "+rs.getInt(7)+" "+"result - "+rs.getString(8));
}
conn.close();
}catch(Exception e){
System.out.println(e);
}
}
}
Statement smt = conn.createStatement();
//smt.executeUpdate("alter table students drop last ");
//smt.executeUpdate("alter table students add column last varchar(15)");
//smt.executeUpdate("delete from students where id = 8");
//smt.executeUpdate("insert into students values(9,'pradeep','kumar','inter','mpc',54636,85,'pass','A')");
System.out.println("data is inserting to the databade......");
ResultSet rs= smt.executeQuery("select * from students");
while(rs.next())
{
System.out.println("id - "+rs.getInt(1)+" "+"fname - "+rs.getString(2)+" "+"lname - "+rs.getString(3)+" "+"class - "+rs.getString(4)+" "+"subject - "+rs.getString(5)+" "+"mobileno - "+rs.getInt(6)+" "+"marks - "+rs.getInt(7)+" "+"result - "+rs.getString(8));
}
conn.close();
}catch(Exception e){
System.out.println(e);
}
}
}
Related posts
Share this post
0 comments: