package med;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Dbconn
{
public Connection c;
public Statement st;
public ResultSet rs;
public void connDb()
{
try
{
Class.forName("com.mysql.jdbc.Driver");
c=DriverManager.getConnection("jdbc:mysql://localhost:3306/medical","root","root");
System.out.println("Database Now Connected");
}
catch(Exception e)
{
System.out.println("Db Connection Errot..."+e.getMessage());
}
}
public boolean checklogin(String uname, String pass) throws SQLException
{
connDb();
st=c.createStatement();
boolean s=false;
rs=st.executeQuery("select * from regdet where username='"+uname+"' and pass='"+pass+"'");
s=rs.next();
return s;
}
public int insertData(String finame, String laname, String emailadd, String usename, String passw) throws SQLException
{
connDb();
st=c.createStatement();
int i=st.executeUpdate("insert into regdet(finame,laname,email,username,pass)values('"+finame+"','"+laname+"','"+emailadd+"','"+usename+"','"+passw+"')");
return i;
}
public int insertpadate(String paname, String paage, String gend, String diss, String pfood, String timedates) throws SQLException
{
connDb();
st=c.createStatement();
int i=st.executeUpdate("insert into padetail(paname,age,gender,discease,food,timeda)values('"+paname+"','"+paage+"','"+gend+"','"+diss+"','"+pfood+"','"+timedates+"')");
return i;
}
public String[] storedata() throws SQLException
{
connDb();
String data[]=new String[100];
st=c.createStatement();
rs=st.executeQuery("select discease from padetail");
int i=0;
while(rs.next())
{
data[i]=rs.getString("discease");
i++;
}
return data;
}
}
