Neha Kaushik

java apps with Mysql Database, want to port my database with my apps

is there any possibility of converting all my MYsql db into another like sqlite.. i mean i have developed my whole apps using mysql.. now changing db leads to a bulk of changes and more thing is i does not have any knowledge about sqlite..
my apps is a window based application.. so there is no need of a server which should be shared by all its users..
Regards..

11 years ago

java apps with Mysql Database, want to port my database with my apps

I have prepared an application that is a small demo of Student information manipulation. I have stored information related to students in a MySQL DB. Now my application is working 100% on my computer. But I want that work everywhere without depending on Database! I mean I just want "WHEREVER MY .JAR FILE GOES, DATABASE SHOULD ALSO GO ALONG WITH THAT INSIDE .JAR FILE "

So anyone who is using my application or trying it, they can realize exact result of this application.

How can I make this possible? Please someone help me.

For that I have done the following things:

1. I have installed MySQL database on my computer.

2. I have created a database on that MySQL server

3. I have created some tables in the database with a lots of data.. this data is to be used in my whole application, even for login.

Now I want to deliver this application to various clients but my clients are not technical persons and I don't want to give instructions to each of my client to do the above steps.

How can I integrate some functionality into my app so that they can use my database, Tables and Data automatically .

Regards..

11 years ago

Hey guys

I'm currently developing an Equipment approval System. I'm using Java and mySQL as the database. I'm getting fairly close to finishing it all I need to do is add a few analytical abilities to it and to install it on another's pc.

But one thing I'm wondering now is how will I set up the database on their computer? Will I have to actually download mySQL and set up the tables etc? I've only done brief searches .

I was hoping anyone who has had experience in doing something similar could point me in the right direction.

Regards

11 years ago

thanks for the help ...
i also got the sql query ..
SELECT distinctrow request.file_no , request.file_subject , request.hardware_request , approval.quantity , approval.approved_quantity FROM request INNER JOIN approval ON request.id = approval.id WHERE request.selected_department = '" + click + "' and approval_date Between '" + d + "' And '" + d1 + "' "

where d1 and d is
java.util.Date date= fromchooser.getDate(); //fromchooser is jdatechooser for startdate
long dateTime = date.getTime();
java.sql.Date d = new Date(dateTime);
java.util.Date date1= tochooser.getDate(); //tochooser is jdatechooser for enddate
long dateTime1 = date1.getTime();
java.sql.Date d1 = new Date(dateTime1);

11 years ago

sir this is sql question i want correct sql query to search data from database between two dates ..

11 years ago

How can i get value from 2 JDateChooser formatted yyyy-MM-d and put it in sql query (String sql="select .... from ... between date1 and date2") which should search data between those dates and outputted in a JTable.

I used code but no output appeared:

try {
Connection con1 = DBConnection.connect();

int index = jList1.getSelectedIndex();
String click = (jList1.getModel().getElementAt(index).toString());

String sql = "SELECT distinctrow request.file_no , request.file_subject , request.hardware_request , approval.quantity , approval.approved_quantity FROM request INNER JOIN approval ON request.id = approval.id WHERE request.selected_department = '" + click + "' ";

PreparedStatement pst = con1.prepareStatement(sql);
ResultSet rst = pst.executeQuery();
ResultSetMetaData rsMetaData = (ResultSetMetaData) rst.getMetaData();
int cols = rsMetaData.getColumnCount();
System.out.println("database" + cols);
for (int i = 1; i < cols; i++) {
columnNames.addElement(rsMetaData.getColumnName(i));
}
System.out.println("while ke baher");

while (rst.next()) {
System.out.println("while ke ander");

Vector row = new Vector(cols);

for (int i = 1; i <= 1; i++) {
row.addElement(rst.getObject(i));
}
int ro = row.size();
System.out.println(ro + "row val");
for (int i = 1; i <= 1; i++) {

String file_no = rst.getString("file_no");
System.out.println(file_no);
String sub = rst.getString("file_subject");
System.out.println(sub);
String hard = rst.getString("hardware_request");
System.out.println(hard);
String rquan = rst.getString("quantity");
System.out.println(rquan);
String aquan = rst.getString("approved_quantity");
System.out.println(aquan);

//
DefaultTableModel model1 = (DefaultTableModel) mis_dept.getModel();

model1.addRow(new Object[]{ file_no, sub,hard,rquan, aquan});
}
}

//
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Error in submitting data!" + ex);
}

please tell me how i use the where clause with 2 conditions as i use WHERE request.selected_department = '" + click + "' "...
and 2nd clause to search data between two dates..
any help will be apperitiated...

11 years ago

populating combobox from database

here instead of using
model.addElement() you should use JcomboBox.addItem();
thankyou..

11 years ago

sorting and filtering in jcombobox binded with database in netbeans

hello...
i hava a problem in sorting and filtering in jcombobox binded with database in netbeans . i have done binding of this jcombobox with database table using netbeans.
that jcombobox contains department names in it. now i want to show this jcombobox data sorted in ascending order.
i also want autosuggestion in it.
for eg
Press "T" -> It will drop-down display everything beginning with "T"

Press "i" -> It will drop-down display everything that begins with "Ti"

Press "m" -> It will drop down display everything that has "Tim" at the beginning.

here is my code which i tried...

private void sort(){
ComboBoxModel Lmodel = comboDeprtmnt.getModel();
List list = new ArrayList<>();

for(int i= 0 ; i <comboDeprtmnt.getItemCount() ; i++)
{
String obj = (Lmodel.getElementAt(i).toString());
char[] arr = obj.toCharArray();
list.add(obj);
Arrays.sort(arr);
System.out.println(list);

Arrays.binarySearch(arr, c);
}

}

i get the character as...
char c;
private void comboDeprtmntKeyReleased(java.awt.event.KeyEvent evt) {
c= evt.getKeyChar();

}

please help i am new in java ...
any help will be appreciated.....

11 years ago

Sir Swastik Dey,
i already tried for Jsmoother but i think i could not used it well..
i dont knoe how to use jsmoother..

11 years ago

how can i build a runnable jar file..
is there some commands or any software for it..
is it that method of building runnable jar file in which we make a menifest file and execute jar cvfm command

11 years ago

i have used java programming and jvm

11 years ago

how to make a .exe file of my project..
i have made my project in netbeans..
i have used mysql database also..
thn how to use database files in making .exe
also i dont know where my database files resides .. i searched for that but could not found anything..
i also have entity classes and pesistence.xml file
.. please help someone ..
any help will be appriciated .. thanks in advance..

11 years ago