java code series(basic to advance)
Code 1: simple code for display massage
public class Mark {
public Mark() {
// TODO Auto-generated constructor stub
}
public static void main(String[] args) {
// TODO Auto-generated method stub
System.out.println("hello this mark first program and hope to soon make more program");
System.out.println("mark is series to make java program effective ");
}
}
Code 2: Connection database
import java.sql.*;
public class Mark1Connection {
Connection conn=null;
PreparedStatement ps= null;
public Mark1Connection() {
// TODO Auto-generated constructor stub
System.out.println("this program connect with database and show enter some information");
// connection code
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("class load");
}catch(Exception e)
{
System.out.println("not run class name");
System.out.println(e);
}
try {
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/connection","root","1234");
System.out.print("succsseful connection");
}catch(Exception e)
{
System.out.println(e);
}
try {
ps=conn.prepareStatement("INSERT INTO `connection`.`login`(`idnumber`,`username`,`password`) VALUES('2','prabhat','prabhat');");
}catch(Exception e) {
System.out.println(e);
}
int status;
try {
status = ps.executeUpdate();
if(status!=0)
System.out.println("successfully register move to next page");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
new Mark1Connection();
}
}
Code 3: Connection database and login
import java.sql.*;
public class Mark2 {
Connection conn=null;
PreparedStatement ps= null;
ResultSet rt= null;
boolean status= false;
String uname="admin";
String pword="admin";
public Mark2() {
// TODO Auto-generated constructor stub
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("class load");
}catch(Exception e)
{
System.out.println("not run class name");
System.out.println(e);
}
try {
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/connection","root","1234");
System.out.println("succsseful connection");
}catch(Exception e)
{
System.out.println(e);
}
try {
ps=conn.prepareStatement("select * from connection.login where username=\""+uname+"\" and password=\""+pword+"\";");
rt= ps.executeQuery();
if(rt.next())
{
status=true;
}
} catch (Exception e) {
System.out.println(e);
}
if(status==true)
{
System.out.println(status+" and "+uname+" "+pword );
}
else
{
System.out.println(status+"erro to login");
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
new Mark2();
}
}
No comments:
Post a Comment