Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.*;
- import java.sql.*;
- public class PrintDate
- {
- public String [] getDate()
- {
- try {
- DriverManager.registerDriver(new com.mysql.jdbc.Driver());
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost/storage?user=root&password=root");
- Statement stm = con.createStatement();
- ResultSet rs = stm.executeQuery("select count(*) from goods");
- rs.next();
- int size=4*rs.getInt(1);
- String data [] = new String[size];
- rs = stm.executeQuery("select * from goods");
- int i=0;
- while (rs.next())
- {
- data[i]=rs.getString(1);
- data[i+1]=rs.getString(2);
- data[i+2]=rs.getString(3);
- data[i+3]=rs.getString(4);
- i=i+4;
- }
- rs.close();
- stm.close();
- con.close();
- return data;
- }
- catch(Exception e) {String dt [] = new String[1]; dt [0]="Error"; return dt;}
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement