MCS-051-Ignou Assignment Guru PDF

Preview

Summary

Download MCS-051-Ignou Assignment Guru PDF

Description

BCA & MCA (IGNOU) http://www.ignouassignmentguru.com

Q2-b package test; importjava.sql.Connection; importjava.sql.DriverManager; importjava.sql.ResultSet; importjava.sql.SQLException; importjava.sql.Statement; //import com.mysql.jdbc.Driver;

/IGNOUASSIGNMENTGURU

IGNOU ASSIGNMENT GURU Page-

Class.forName("com.mysql.jdbc.Driver").newInstance(); // conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdatabase ?user=testuser&password=testpassword"); String connectionUrl = "jdbc:mysql://localhost:3306/testdatabase"; String connectionUser = "testuser"; String connectionPassword = "testpassword"; conn = DriverManager.getConnection(connectionUrl, connectionUser, connectionPassword); stmt = conn.createStatement(); rs = stmt.executeQuery("SELECT * FROM employees"); while (rs.next()) { String id = rs.getString("id"); String firstName = rs.getString("first_name"); String lastName = rs.getString("last_name"); System.out.println("ID: " + id + ", First Name: " + firstName + ", Last Name: " + lastName);

1

publicclassMySqlJdbcTest { publicstaticvoid main(String[] args) { Connection conn = null; Statement stmt = null; ResultSetrs = null; try { // new com.mysql.jdbc.Driver();

BCA & MCA (IGNOU)

http://www.ignouassignmentguru.com

} } catch (Exception e) { e.printStackTrace(); } finally { try { if (rs != null) rs.close(); } catch (SQLException e) { e.printStackTrace(); } try { if (stmt != null) stmt.close(); } catch (SQLException e) { e.printStackTrace(); } try { if (conn != null) conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } Q-3 (1) CREATETABLE`users` ( `first_name` VARCHAR(100) NOTNULL, `last_name` VARCHAR(100) NOTNULL, `email_address` VARCHAR(50) NOTNULL, `secret_question` VARCHAR(200) NULLDEFAULTNULL, `secret_answer` VARCHAR(200) NULLDEFAULTNULL, `user_name` VARCHAR(100) NOTNULL, `password` VARCHAR(100) NOTNULL, PRIMARYKEY(`user_name`) ) COLLATE='latin1_swedish_ci' ENGINE=InnoDB;

} catch(SQLExceptionsqle) { System.out.println("SQLException: Unable to execute query : "+strQuery); throwsqle; } catch(Exception e) { System.out.println("Exception: Unable to execute query: "+strQuery); throwe; } finally{

/IGNOUASSIGNMENTGURU

IGNOU ASSIGNMENT GURU Page-

try{ conn = getConnection(); Statement stmt =conn.createStatement(); stmt.executeUpdate(strQuery);

2

publicstaticvoidexecuteQuery(String strQuery) throwsException { Connection conn = null;

BCA & MCA (IGNOU)

http://www.ignouassignmentguru.com

closeConnection(conn); } } Q-3 (2) if(isset($_POST['submit1'])||isset($_POST['submit1'])){ $login = $_POST['login']; $query_login="SELECT login FROM registration WHERE login='$login';"; $result_login=mysqli_query($conn,$query_login); $anything_found=mysqli_num_rows($result_login); //check if the username already exists if($anything_found>0) { echo"Sorry, that Username is already taken. Please choose another."; returnfalse;} else{//proceed with registration form action="myform.php" method="post"> Choose a username :...