Expand|Select|Wrap|Line Numbers
- String data = "%1:zetakalyam:arjun";
- if (data.startsWith("%1")) {
- String str = data;
- String[] cmd;
- String delimiter = "%|\\$|\\:|\\#";
- cmd = str.split(delimiter);
- System.out.println(cmd.length);
- for (int i = 0; i < cmd.length;i++) {
- System.out.println("cmd of " +i+ "=" +cmd[i]);
- }
- Connection con = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- String conURL = "jdbc:mysql://localhost/employee";
- con = DriverManager.getConnection(conURL, "root", "root");
- DatabaseMetaData dbm = con.getMetaData();
- ResultSet tables = dbm.getTables(null, null, "+cmd[2]+", null);
- if (tables.next()) { //if table exists
- Statement st = con.createStatement();
- String query = "insert into " + cmd[2] + "
- (name,employee_id,date,logout) select
- name,employee_id,curdate(),'0' from tbi where name = '" + cmd[3] + "'";
- ResultSet rs1 = st.executeQuery(query);
- }
- else{
- System.out.println("table does not exists");
- }
- }
- catch(ClassNotFoundException | SQLException e){
- }
i have a database called employee, which contains a table zetakalyam But, i get the result as table does not exists:(
i have checked the database and it shows the table in its list