Skip to content

Commit e6322b3

Browse files
sikindersikinder
committed
2 parents d026c5b + e31009a commit e6322b3

File tree

8 files changed

+311
-0
lines changed

8 files changed

+311
-0
lines changed

‎build.xml‎

Lines changed: 83 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,83 @@
1+
<?xml version="1.0"?>
2+
<!--
3+
hello hi
4+
-->
5+
<project name="java-junit-template-project" default="run" basedir=".">
6+
<property name="version" value="30.0.0"/>
7+
<property name="main.build.dir" value="build/main" />
8+
<property name="main.src.dir" value="src" />
9+
<property name="test.build.dir" value="build/test" />
10+
<property name="test.src.dir" value="ServerEnvTestCases" />
11+
12+
<path id="classpath.base" >
13+
<pathelement location="lib/mysql-connector-java-5.1.38-bin.jar"/>
14+
</path>
15+
16+
<path id="classpath.test">
17+
<pathelement location="lib/junit-4.10.jar" />
18+
<pathelement location="build/jar/Project.jar"/>
19+
<pathelement location="lib/mysql-connector-java-5.1.38-bin.jar"/>
20+
<path refid="classpath.base" />
21+
</path>
22+
23+
<target name="test" depends="clean, run" />
24+
<target name="Jar" depends="compile">
25+
<mkdir dir="./build/jar"/>
26+
<jar destfile="./build/jar/Project.jar" basedir="${main.build.dir}">
27+
<zipgroupfileset dir="./lib" includes="*.jar"/>
28+
<manifest>
29+
<attribute name="Main-Class" value="com.netenrich.Main"/>
30+
<attribute name="Implementation-Version" value="${version}"/>
31+
</manifest>
32+
</jar>
33+
</target>
34+
<target name="compile" depends="clean">
35+
<mkdir dir="${main.build.dir}"/>
36+
<javac srcdir="${main.src.dir}" destdir="${main.build.dir}" includeantruntime="false">
37+
<classpath refid="classpath.base"/>
38+
</javac>
39+
</target>
40+
41+
<target name="build" depends="Jar">
42+
<!--
43+
<mkdir dir="${test.build.dir}"/>
44+
45+
<javac srcdir="${test.src.dir}" destdir="${test.build.dir}" includeantruntime="false">
46+
<classpath refid="classpath.test"/>
47+
</javac>
48+
-->
49+
<echo message="Build done" />
50+
</target>
51+
52+
<!-- Test and build all files -->
53+
<!-- To run this: use "ant" (default) or "ant run" -->
54+
<target name="run" depends="build">
55+
<!--
56+
<junit printsummary="on" haltonfailure="no">
57+
<classpath>
58+
<path refid="classpath.test" />
59+
<pathelement location="${test.build.dir}"/>
60+
</classpath>
61+
<formatter type="brief" usefile="false" />
62+
<formatter type="xml"/>
63+
<formatter type="plain"/>
64+
<batchtest>
65+
<fileset dir="${test.src.dir}" includes="**/*Test*.java" />
66+
67+
</batchtest>
68+
</junit>
69+
<delete dir="${test.src.dir}"/>
70+
-->
71+
<echo message="Done" />
72+
</target>
73+
74+
<!-- delete all class files -->
75+
<!-- To run this: use "ant clean" -->
76+
<target name="clean">
77+
<delete>
78+
<fileset dir="${basedir}" includes="**/*.class" />
79+
</delete>
80+
<delete dir="./build"/>
81+
<echo message="clean done" />
82+
</target>
83+
</project>

‎lib/junit-4.10.jar‎

247 KB
Binary file not shown.

‎lib/mysql-connector-java-5.1.38-bin.jar‎

961 KB
Binary file not shown.

‎src/com/netenrich/DatabaseDetails.java‎

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
package com.netenrich;
2+
3+
public class DatabaseDetails {
4+
private String database_url = "jdbc:mysql://localhost/register";
5+
private String database_username = "root";
6+
private String database_password = "root123";
7+
public String Databaseurl(){
8+
return database_url;
9+
10+
}
11+
public String Databaseusername(){
12+
return database_username;
13+
}
14+
public String Databasepassword(){
15+
return database_password;
16+
}
17+
}

‎src/com/netenrich/Databaseconnection.java‎

Lines changed: 41 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,41 @@
1+
package com.netenrich;
2+
3+
import java.sql.Connection;
4+
import java.sql.DriverManager;
5+
import java.sql.SQLException;
6+
7+
public class Databaseconnection {
8+
private String username;
9+
private String password;
10+
private String database_url;
11+
12+
13+
public Databaseconnection(String user_name,String Password,String databaseurl){
14+
this.username=user_name;
15+
this.password=Password;
16+
this.database_url = databaseurl;
17+
}
18+
public Connection Access_Database(){
19+
java.sql.Connection connection=null;
20+
try {
21+
22+
Class.forName("com.mysql.jdbc.Driver").newInstance();
23+
connection = DriverManager.getConnection(database_url,username,password);
24+
25+
26+
} catch (SQLException e) {
27+
// TODO Auto-generated catch block
28+
29+
} catch (InstantiationException e) {
30+
// TODO Auto-generated catch block
31+
32+
} catch (IllegalAccessException e) {
33+
// TODO Auto-generated catch block
34+
35+
} catch (ClassNotFoundException e) {
36+
// TODO Auto-generated catch block
37+
38+
}
39+
return connection;
40+
}
41+
}

‎src/com/netenrich/Login.java‎

Lines changed: 40 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,40 @@
1+
package com.netenrich;
2+
3+
import java.sql.*;
4+
5+
public class Login {
6+
private String user_name;
7+
private String password;
8+
public Login(String user_name,String pass){
9+
this.user_name = user_name;
10+
this.password = pass;
11+
}
12+
public String validate(){
13+
String output="";
14+
DatabaseDetails main = new DatabaseDetails();
15+
String database_url = main.Databaseurl();
16+
String database_username = main.Databaseusername();
17+
String database_password = main.Databasepassword();
18+
Databaseconnection db_connection = new Databaseconnection(database_username,database_password,database_url);
19+
java.sql.Connection connection = db_connection.Access_Database();
20+
String query = "SELECT * FROM register WHERE email_id=\""+user_name+"\" && password=\""+password+"\"";
21+
try {
22+
Statement stmnt = connection.createStatement();
23+
ResultSet rs = stmnt.executeQuery(query);
24+
int count=0;
25+
while (rs.next()){
26+
count = count+1;
27+
}
28+
if (count>0){
29+
output = "You are logged in.";
30+
}
31+
else{
32+
output = "Login Failed.";
33+
}
34+
} catch (Exception e) {
35+
// TODO Auto-generated catch block
36+
e.printStackTrace();
37+
}
38+
return output;
39+
}
40+
}

‎src/com/netenrich/Main.java‎

Lines changed: 40 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,40 @@
1+
package com.netenrich;
2+
import java.util.*;
3+
import java.sql.*;
4+
public class Main {
5+
private static Scanner input;
6+
public static void main(String args[]) throws SQLException{
7+
String ver = com.netenrich.Main.class.getPackage().getImplementationVersion();
8+
System.out.println("Current Version of Application: "+ver);
9+
input = new Scanner(System.in);
10+
System.out.println("1.Register");
11+
System.out.println("2.Login");
12+
System.out.println("Enter A Number Corresponding To Your Option(hi):");
13+
int choice = input.nextInt();
14+
if (choice == 1){
15+
System.out.println("Enter First Name:");
16+
String first_name = input.next();
17+
System.out.println("Enter Last Name:");
18+
String last_name = input.next();
19+
System.out.println("Enter Email ID:");
20+
String email_id = input.next();
21+
System.out.println("Enter Password:");
22+
String password = input.next();
23+
Register register = new Register(first_name,last_name,email_id,password);
24+
String result1 = register.InsertDetails();
25+
System.out.println(result1);
26+
}
27+
else if (choice==2){
28+
System.out.println("Enter UserName:\t");
29+
String user_name = input.next();
30+
System.out.println("Enter Password:\t");
31+
String password = input.next();
32+
Login login = new Login(user_name,password);
33+
String result2 = login.validate();
34+
System.out.println(result2);
35+
}
36+
else{
37+
System.out.println("No Choice found.");
38+
}
39+
}
40+
}

‎src/com/netenrich/Register.java‎

Lines changed: 90 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,90 @@
1+
package com.netenrich;
2+
import java.sql.*;
3+
public class Register {
4+
private String first_name;
5+
private String last_name;
6+
private String email_id;
7+
private String password;
8+
public Register(String first,String last,String email,String pass){
9+
this.first_name = first;
10+
this.last_name = last;
11+
this.email_id = email;
12+
this.password = pass;
13+
14+
}
15+
public String InsertDetails(){
16+
String output=null;
17+
DatabaseDetails main = new DatabaseDetails();
18+
String database_url = main.Databaseurl();
19+
String database_username = main.Databaseusername();
20+
String database_password = main.Databasepassword();
21+
Databaseconnection db_connection = new Databaseconnection(database_username,database_password,database_url);
22+
java.sql.Connection connection = db_connection.Access_Database();
23+
Statement stmnt1 = null;
24+
try {
25+
String stmnt = "INSERT INTO register (first_name,last_name,email_id,password) VALUES (?,?,?,?)";
26+
PreparedStatement ps = connection.prepareStatement(stmnt);
27+
ps.setString(1, first_name);
28+
ps.setString(2, last_name);
29+
ps.setString(3, email_id);
30+
ps.setString(4, password);
31+
String query = "SELECT * FROM register WHERE email_id=\""+email_id+"\"";
32+
stmnt1 = connection.createStatement();
33+
ResultSet rs = stmnt1.executeQuery(query);
34+
int count = 0;
35+
while (rs.next()){
36+
String user_name = rs.getString("email_id");
37+
if (user_name.equals(email_id)){
38+
count = count+1;
39+
}
40+
}
41+
if (count==0){
42+
int result = ps.executeUpdate();
43+
if (result==1){
44+
output = "You are Successfully Registered.";
45+
}
46+
else{
47+
output = "Your Registration Failed.";
48+
}
49+
}
50+
else{
51+
output= "Email ID is Already Registered.";
52+
}
53+
} catch (SQLException e) {
54+
// TODO Auto-generated catch block
55+
}
56+
return output;
57+
}
58+
public String checkDetails(){
59+
String output=null;
60+
DatabaseDetails main = new DatabaseDetails();
61+
String database_url = main.Databaseurl();
62+
String database_username = main.Databaseusername();
63+
String database_password = main.Databasepassword();
64+
Databaseconnection db_connection = new Databaseconnection(database_username,database_password,database_url);
65+
java.sql.Connection connection = db_connection.Access_Database();
66+
Statement stmnt1 = null;
67+
try {
68+
String sql = "SELECT email_id FROM register WHERE email_id=\""+email_id+"\"";
69+
stmnt1 = connection.createStatement();
70+
ResultSet rs = stmnt1.executeQuery(sql);
71+
int count = 0;
72+
while(rs.next()){
73+
//Retrieve by column name
74+
String email = rs.getString("email_id");
75+
count=count+1;
76+
}
77+
if (count>0){
78+
output= "Email ID is Already Registered.";
79+
}
80+
else{
81+
output = "Your can Register.";
82+
}
83+
} catch (SQLException e) {
84+
// TODO Auto-generated catch block
85+
}
86+
return output;
87+
}
88+
89+
90+
}

0 commit comments

Comments
 (0)