卢晶晶的博客

字符串函数upper：转成大写select * from Student where upper(Sdept)='CS';lower：转成小写select * from Student where lower(Sdept)='cs';initcap:将首字母转大写，其他小写select initcap('hello world') from dual;substr：...

package edu.yangtzeu.lmis.util;import java.sql.Connection;import java.sql.DriverManager;//数据库工具类public class Dbutil { String dbUrl = "jdbc:sqlserver://localhost\\SQLEXPRESS:1433;DatabaseName=L...