Answer to Question #236086 in Java | JSP | JSF for binura

Question

I used Netbeans to do my project

Student can Update, Add, Remove a issue

The added issue need to notify admin to send a reply ,notification either can be shown in database(mysql) with student name and nic , or send a notification to email but if send email is not good because student can modify update anytime so,i think its easy to use db because admin can look for messagers with name ,nic message. can anyone code for this requirement.

Thank you

Answer 1

import java.sql.*;  
class MysqlCon{  
public static void main(String args[]){  
try{  
Class.forName("com.mysql.jdbc.Driver");  
Connection c=DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","root");  
Statement s=c.createStatement();  
ResultSet rs=s.executeQuery("select * from Students");  
while(rs.next())  
System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));  
c.close();  
}catch(Exception e){ System.out.println(e);}  
}  
}