QiuBika_061的博客

import java.sql.*; public class SqlLink { public static void main(String []args) { String driverName="oracle.jdbc.OracleDriver"; //协议、主机地址、端口号、数据库名 String dbURL=...

mysql运行报The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone 解决方法： 运行语句：set GLOBAL time_zone='+8:00';

/* 删除数据SQL语句 删除姓名为叶十四的人的信息 */ String delSql = "delete from 超级数据库.. 超级表1 where 姓名='叶十四';"; /* 删除数据SQL语句 删除超级表中所有数据 */ ...

/* 修改数据SQL语句 将编号为12的人的姓名改为叶十四 */ String updSql = "update 超级数据库.. 超级表1 set 姓名='叶十四' where 编号='12'"; /* 修改数据SQL语句 将所有人的年龄+1 *...

/* 插入数据SQL语句 要插入的列：编号,姓名,年龄,性别,工资,出生日期 插入的数据：012,'秦十四',23,'男',5252,null 插入的列和数据必须一一对应 */ String addSql = "insert into 超级数据库.. 超级表1(编号,姓名,年龄,性别...

import java.sql.*; import java.util.ArrayList; import java.util.Collection; import java.util.Iterator; public class Test { static Connection dbConn=null; public static void main(String[] a...

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class Test { static Connection dbConn=null; public static void ma...

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class Test { static Connection dbConn=null; public static void ma...

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class Test { static Connection dbConn=null; public static void ma...

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class Test { static Connection dbConn=null; public static void ma...

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class Test { static Connection dbConn=null; public static void ma...

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class Test { static Connection dbConn=null; public static void ma...

import java.sql.*; public class SqlLink { public static void main(String []args) { String userName = "TangHao"; String userPwd = "tanghao6.1"; String driverName="co...

import java.sql.*; import java.util.ArrayList; import java.util.List; import java.util.Scanner; public class SqlLink { static Scanner sc=new Scanner(System.in); static Connection dbConn=nul...