Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- static BufferedReader tec=new BufferedReader (new InputStreamReader(System.in));
- public static void main(String[] args) {
- String jdbcUrl = "jdbc:mysql://localhost:3306/ciclismo" ;
- Connection con = null;
- PreparedStatement pstmt = null;
- ResultSet rs = null;
- String nomEquipo="ONCE";
- try{
- con = DriverManager.getConnection(jdbcUrl, "root", "mysql");
- //a
- //4 valores codigo, tipo, color, premio
- pstmt=con.prepareStatement("insert into maillot values(?,?,?,?)");
- //coger valor del campo 1 (codigo)
- String cod = tec.readLine();
- pstmt.setString(1, cod);
- //coger valor del campo 2 (tipo)
- String tipo = tec.readLine();
- pstmt.setString(2, tipo);
- //coger valor del campo 3 (color)
- String color = tec.readLine();
- pstmt.setString(3, color);
- //coger valor del campo 4 (premio)
- int premio = Integer.parseInt(tec.readLine());
- pstmt.setInt(4, premio);
- pstmt.executeUpdate();
- //b
- int edad [] = {20,25};
- String [] equipo = {"BANESTO", "ONCE"};
- String sql = "select dorsal, nombre, from ciclista, where nomeq =? and year (current_date())-year(nacimiento)>?";
- pstmt = con.prepareStatement(sql);
- int len = edad.length;
- for (int i = 0; i < len; i++) {
- pstmt.setString(1,equipo[i]);
- pstmt.setInt(2, edad[i]);
- rs = pstmt.executeQuery();
- System.out.println("mayores de: "+edad[i]);
- while(rs.next()){
- Integer dorsal = rs.getInt(1);
- String nom = rs.getString(2);
- System.out.println(equipo[i]+ " "+ nom+" - "+dorsal);
- }
- }
- } catch (Exception e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement